Write a code for MySQL for the following query "List all recipes that are main courses (recipe class is 1) and that have notes. (4 rows)."

 

Administration SCHEMAS Q Filter objects > > A > > > EntertainmentAgencyE... A A on BowlingLeagueExample database_name Schemas new_schema Recipes Example Tables Ingredient_Classes Ingredients Measurements Recipe_Classes Columns Indexes Foreign Keys Triggers Recipe_Ingredients Recipes RecipeClassID RecipeClassDe... > SalesOrdersExample Views Stored Procedures Functions rent_hw2 world SchoolSchedulingExam... Query 1 1. 2. 3 100% Result Grid 1 7700 2345 Recipeld RecipeTitle Irish Stew Salsa Buena recipes 1 use recipesexample; select RecipeId, RecipeTitle from recipes where RecipeID between 1 and 5; 32:3 Action Output SQL File 3* Time Machos Nachos Garlic Green Beans Fettuccini Alfredo UU.UU.15 SQL File 4* Filter Rows: Q Search SQL File 6* Action USE DUWinny Leaguecxample Limit to 1000 rows Export: SQL File 7* SQL File 8* 4 SQL File 9* Response OTOW (Sainected 29 30 00:00:13 SELECT TourneyDate FROM Tournaments WHERE TourneyLocation IN ('Red Rooster Lanes', 'Bo... 6 row(s) returned 31 00:00:57 USE BowlingLeagueExample O row(s) affected 32 00:00:57 SELECT BowlerID, Bowler LastName, BowlerFirstName, BowlerMiddlelnit, BowlerAddress, Bowle... O row(s) returned