Details of this Paper

simple SQL queries

Description

solution


Question

simply SQL queries that will allow me to find the information i need from the database that im given.;4. Select name and seaso n fro m EPISODES, a liasing name to ? Show Title? and seaso n to ? Sea son No?;8. Count the instances where ?The? appears in a name;9. Select name, season from EPISODES where ?the? does not appear;10. Select name, season from EPISODES where episode was in the second season;11. Select name, season from EPISODES where episode was in the second or fifth season;12. Count EPISODES where episode was in the second or fifth season;13. Count seasons, aliasing count as ?Number of Season?;14. Count number of episodes per season;15. Show episodes with no season;16. Join FOODS with FOOD_TYPES, displaying the name column of each;17. Display the frequency of food_types in FOODS;18. Display foods and their prices (join FOOD and FOOD_PRICES);19. Display each food and its price;20. Display each food, its price, and its food type, showing the most expensive first;21. List total amount for each food type;22. List foods referenced in each episode

 

Paper#70848 | Written in 18-Jul-2015

Price : $27
SiteLock