SQL Querying Quiz

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Download our mobile app to listen on the go

Get App

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)

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; (D)</p>

Signup and view all the answers

<p>SELECT promo_category, SUM(promo_cost) AS total_cost FROM promotions GROUP BY promo_category; (D)</p>

Signup and view all the answers

Flashcards are hidden until you start studying