simple SQL queries

aco249
Home>Homework Answsers>Computer Science homework help

simply SQL queries that will allow me to find the information i need from the database that im given. 

 

4.   Select    name    and    season    from EPISODES,    aliasing    name    to    “Show    Title” and season to    “Season    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   

 

    • 12 years ago
    • 20
    Report issue
    Answer(1)
    jordanblink
    5.0 (68)
    5.0 (62)
    Chat

    Purchase the answer to view it

    NOT RATED
      Bids(0)