Details of this Paper

SQL.

Description

solution


Question

I need the answers to the following questions. I need to provide the proper SQL queries that would be used in order for me to search a certain database that i have been given.;example would be...;7. Select name, seaso n fro m EPISODES where ?GUY? is contained in name;SELECT name, season FROM episodes;WHERE name LIKE "%guy%;8. Count the instances where ?The? appears in a name;9. Select name, seaso n fro m EPISODES where ?the? does not a ppear;10.Select name, seaso n fro m EPISODES w here e p isode w as in the second se a son;11.Select name, seaso n fro m EPISODES w here e p isode w as in the second or fifth season;12.Count EPISODES w here e p isode w as in the second or fi fth seaso n;13.Count seasons, aliasing count as ?Number of Season?;14.Count number of e p isodes p er seaso n;15.Show episodes w ith no seaso n;16.Join F O OD S with F O O D _ T Y PES, displaying the name column of ea ch;17.Display the freq u ency of food_types in F O OD S;18.Display foo d s and their prices (join F O O D and F O O D _ PRICE S);19.Display each food and its price;20.Display each food, its price, and its food type, sho w ing the most expensive firs t;21.List total amount for each food type;22.List foods refere n ced in each episode

 

Paper#70844 | Written in 18-Jul-2015

Price : $27
SiteLock