Project: Davie's Burgers Subway Ad | Codecademy | Analyze data with SQL | 2. Writing basic queries | Extra practice

DavieBurgers_subway_ad.txt

SELECT *
FROM orders
LIMIT 10;

SELECT DISTINCT order_date
FROM orders;

SELECT special_instructions
FROM orders
LIMIT 20;

SELECT special_instructions
FROM orders
WHERE special_instructions IS NOT NULL
LIMIT 20;

SELECT special_instructions
FROM orders
WHERE special_instructions IS NOT NULL
ORDER BY special_instructions
LIMIT 20;

SELECT special_instructions
FROM orders
WHERE special_instructions LIKE '%sauce%';

SELECT special_instructions
FROM orders
WHERE special_instructions LIKE '%door%';

SELECT special_instructions
FROM orders
WHERE special_instructions LIKE '%box%';

SELECT ID AS '#',
   special_instructions AS 'Notes'
FROM orders
WHERE special_instructions LIKE '%box%';