Lab: Using SQL in the Lancaster College DatabaseInstructions: Open the Support$\_$AC$\_$Lancaster College database. $($If you do not have the database, see your instructor for a copy of the modified database.$)$Part $1$: The administration at Lancaster College has asked you to perform a number of tasks. Use the concepts and techniques presented in this module to perform each of the following tasks.a$.$ Create queries using SQL$.$ Find all the Orders where the quantity ordered was less than $75.$ Show all fields in the results and save the query as ITL Step $1$ Query. $$b$.$ Create a query using the WHERE command to identify the Coaches with offices in the SM building. Save the query as ITL Step $2$ Query. c$.$ Use the AND command to identify all the students who have waivers and are qualified academically for sports. Show the Student ID field in the query. Save the query as ITL Step $3$ Query. d$.$ Using the NOT command, find all coaches that do not have offices in the JK building. Show the Coach ID field in the query. Save the query as ITL Step $4$ Query.e$.$ Using the ORDER BY command, sort the students that are participating in sports by their student ID and then by the name of the sport they are participating in$.$ Sort both in ascending order. Save the query as ITL Step $5$ Query.f$.$ Use the AND command to find the football fields that are available in the Fall and sort the results in descending order by FieldID. Save the query as ITL Step $6$ Query.g$.$ Group the Orders by Equipment ID and Count the number of orders with quantity ordered of greater than $30.$ Save the query as ITL Step $7$ Query.h$.$ Close the database.