SQL Querying Quiz

SELECT promo_category, MAX(promo_cost) FROM promotions GROUP BY promo_category;

SELECT promo_category, AVG(promo_cost) FROM promotions GROUP BY promo_category;

SELECT promo_category, SUM(promo_cost) FROM promotions GROUP BY promo_category;

SELECT DISTINCT promo_cost, promo_category FROM promotions ORDER BY promo_cost;

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY promo_category; (correct)

unit_price + (surcharge * discount)

(unit_price * 0.15 / (4.75 + 552.25))

(unit_price * surcharge) - discount

unit_price + surcharge - discount (correct)

unit_price || 5 - discount + surcharge

SELECT product_id, (expiry_date / delivery_date) AS days_difference FROM products;

SELECT product_id, EXTRACT(DAY FROM (expiry_date - delivery_date)) AS days_difference FROM products;

SELECT product_id, (expiry_date + delivery_date) AS days_difference FROM products;

SELECT product_id, DATEDIFF(day, delivery_date, expiry_date) AS days_difference FROM products;

SELECT product_id, (expiry_date - delivery_date) AS days_difference FROM products; (correct)

<p>SELECT product_name, unit_price * 0.9 AS discounted_price FROM products;</p> Signup and view all the answers

<p>SELECT promo_category, SUM(promo_cost) AS total_cost FROM promotions GROUP BY promo_category;</p> Signup and view all the answers