Cacher is the code snippet organizer for pro developers

##SQL Lab - October 9th, 2013

1. Download this SQLite database and write a SQL statement that:

   1. Selects the names of all products that are not on sale. select * from products where "on_sale" = "t";

   2. Selects the names of all products that cost less than $20.
      select * from products where "price" < 20;

   3. Selects the name and price of the most expensive product. select name from products order by price;

   4. Selects the name and price of the second most expensive product. select name from products order by price limit 2;

   5. Selects the name and price of the least expensive product. select name from products order by price desc limit 1;

   6. Selects the names and prices of all products, ordered by price in descending order. select name from products order by price desc;

   7. Selects the average price of all products. select price from products avgprice; (?)

   8. Selects the sum of the price of all products. select avg(price) from products;

   9. Selects the sum of the price of all products whose prices is less than $20. select sum(price) from products where "price" < 20;

   10. Selects the id of the user anil. select id from users where "name" = "Anil Bridgpal";

   11. Selects the names of all users whose names start with the letter "A". select * from users where "name" like 'A%';

   12. Selects the number of users whose first names are "Jonathan". select count(name) from users where "name" like 'Jonathan%';

   13. Selects the number of users who want a "Teddy Bear". select users.name from users inner join wishlists on users.id = wishlists."user_id" inner join products on wishlists."product_id" = "product_id" where products.name = "Teddy Bear";

   14. Inserts a user with the name "Jonathan Postel" into the users table.

   15. Selects the id of the user with the name "Jonathan Postel"?

   16. Inserts a wishlist entry for the user with the name "Jonathan Postel" for the product "The Ruby Programming Language".

   17. Updates the name of the "Jonathan Postel" user to be "Jon Postel".

   18. Deletes the user with the name "Jon Postel".

   19. Deletes the wishlist item for the user you just deleted.

   BONUS QUESTIONS

   1. Selects the count of items on the wishlish of the user with your name.
   2. Selects the count and name of all products on the wishlist, ordered by count in descending order.
   3. Selects the count and name of all products that are not on sale on the wishlist, ordered by count in descending order.