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 FOODTYPES, displaying the name column of each 17. Display the frequency of foodtypes in FOODS 18. Display foods and their prices (join FOOD and FOODPRICES) 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
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]