public List<GroceryItem> calculateInvoice(List<GroceryItem> purchasedItems, Map<String, Double> prices, Map<String, Double> discounts) {
    List<GroceryItem> invoiceItems = new ArrayList<>();

    for (GroceryItem purchasedItem : purchasedItems) {
        String itemName = purchasedItem.getItemName();
        int quantity = purchasedItem.getQuantity();

        // Calculate the total price for the item, including the discount.
        double price = prices.get(itemName);
        double discount = discounts.getOrDefault(itemName, 0.0);
        double totalPrice = price * quantity - discount * quantity;

        // Create a new GroceryItem object for the invoice.
        GroceryItem invoiceItem = new GroceryItem(itemName, quantity, price, totalPrice);
        invoiceItems.add(invoiceItem);
    }

    // Sort the invoice items in ascending order by product name.
    invoiceItems.sort(Comparator.comparing(GroceryItem::getItemName));

    return invoiceItems;
}

Grocery items code

Share @coding_000✅

Total stream SQL

Share our channel screenshot in large groups ✅✅✅✅✅

For coding answers &  Sql 🏃🏃🏃🏃

SELECT c.title AS category_title, p.title, SUM(p.stock_number) AS total_stock
FROM categories c
JOIN products p ON c.id = p.category_id
GROUP BY c.title, p.title
HAVING SUM(p.stock_number) > 10
ORDER BY category_title ASC, p.title ASC, total_stock


E commerce website

Share @coding_000✅

Streamers code working 100 percent

Share @coding_000
#CSD #CODING_000

✅ Share @coding_000❤️🆓🆓

SELECT
    A.email AS "email account",
    COUNT(O.account_id) AS "outputs",
    SUM(LENGTH(O.output) - LENGTH(REPLACE(O.output, ' ', '')) + 1) AS "total words",
    ROUND(SUM(LENGTH(O.output) - LENGTH(REPLACE(O.output, ' ', '')) + 1) / COUNT(O.account_id), 2) AS "avg words per output"
FROM accounts A
LEFT JOIN results O ON A.id = O.account_id
GROUP BY A.email
ORDER BY A.email ASC;

NoBody sharing 😢😕
Our channel @Coding_000❤️

SELECT
  categories.title AS category,
  products.title,
  products.stock_number AS total_stock
FROM
  products
INNER JOIN categories ON products.category_id = categories.id
WHERE
  products.stock_number > 10
ORDER BY
  category ASC,
  products.title ASC,
  total_stock DESC;

Share our channel screenshot in large groups ✅✅✅✅✅

For coding answers &  Sql 🏃🏃🏃🏃

SELECT
   DATE_FORMAT(date_field, '%Y-%m') AS month_year,
   'Jobs' AS source,
   COUNT(*) AS total_number
FROM
   jobs
GROUP BY
   month_year
UNION ALL
SELECT
   DATE_FORMAT(date_field, '%Y-%m') AS month_year,
   'Freelancers' AS source,
   COUNT(*) AS total_number
FROM
   freelancers
GROUP BY
   month_year
ORDER BY
   month_year ASC,
   source ASC;

Freelancer code✅ @coding_000❤️

Give reactions...check mark/type it carefully..✅

Share our channel..to get more ans..😅✅

Antivirus code✅

Share @coding_000❤️

🆓🆓🆓 share 😊👍

Q - E-commerce website admin


SELECT c.title AS category_title, p.title, SUM(p.stock_number) AS total_stock
FROM categories c
JOIN products p ON c.id = p.category_id
GROUP BY c.title, p.title
HAVING SUM(p.stock_number) > 10
ORDER BY category_title ASC, p.title ASC, total_stock DESC;

Full code
Share @coding_000❤️✅

E commerce
coding_000✅

SELECT
   DATE_FORMAT(date_field, '%Y-%m') AS month_year,
   'Jobs' AS source,
   COUNT(*) AS total_number
FROM
   jobs
GROUP BY
   month_year
UNION ALL
SELECT
   DATE_FORMAT(date_field, '%Y-%m') AS month_year,
   'Freelancers' AS source,
   COUNT(*) AS total_number
FROM
   freelancers
GROUP BY
   month_year
ORDER BY
   month_year ASC,
   source ASC;

✅✅ share @coding_000✅