write the SQL code for these queries

2. Provide information about each fitness instructor's class schedule, including the instructor's name and id, information about the class itself, the number of members enrolled in each class, the room information, and how many spots are left in the room capacity. Make sure to include information about classes that do not yet have any members enrolled. Enable search by instructor name and the month the class started. 3. Provide a list of supply orders, including contact information for the vendor, the name of the clerk who submitted the order, the order date, the receipt date, the number of days since the order was placed, and whether or not all items were received in full (i.e., quantity ordered matches the qty received). Enable search by vendor and the date the order was placed.