====== Exercise 2 - SQL Basics 1 ====== 1 | Select employees whose firstname starts with letter A. -------------------------------------------------- -------------------------------------------------- ################################################## 2 | Select customers who live in London. -------------------------------------------------- -------------------------------------------------- ################################################## 3 | Select all different cities from customers table. Remember to remove duplicates! -------------------------------------------------- -------------------------------------------------- ################################################## 4 | Select customers whose postal code starts with number 1 and customerID is between 50 and 70. -------------------------------------------------- -------------------------------------------------- ################################################## 5 | Select suppliers operating in any of the following countries: Australia, Finland or Japan. -------------------------------------------------- -------------------------------------------------- ################################################## 6 | Select product categories where the word 'bread' is mentioned in the description column. Any wording is acceptable (bread, breads). -------------------------------------------------- -------------------------------------------------- ################################################## 7 | Select products priced over 20 and packed in either cans or boxes. Order the result set by product name in ascending order. -------------------------------------------------- -------------------------------------------------- ################################################## 8 | Select employees who have been born in 50s or 60s and whose lastname does not start with letters A, B, C or D. Order the result set by employees firstname in descending order. -------------------------------------------------- -------------------------------------------------- ################################################## 9 | Select products with missing price. ProductID, ProductName, Unit and Price should be included in the result set. Use alias name Incomplete for the column. -------------------------------------------------- -------------------------------------------------- ################################################## 10 | Select products with ProductID in range 50-80. Then show only 10 rows starting from ProductID 60 (included in result set). -------------------------------------------------- --------------------------------------------------