Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20) LastName varchar(20) Gender char(1) DateofBirth date Courses Attribute Name Data Type CourseCode varchar(6) CourseName varchar(70) Level char(2) Credits int   Registration Attribute Name Data Type StudentID char(11) CourseCode varchar(6) Grade decimal(2, 1)   Write SQL code to:  1. Find the students who have not registered any course yet. 2. Find the student (studentID only), the sum of grade, and the average of grade, for each student who has registered courses and the average of grade is below 3. 3. Find the student who has registered the most number of courses. If there are multiple students who have registered the most number of courses, just take one student (To take only one record - the 1st record in the returned result, use ‘limit 1’ at the end of your SQL code). 4.Find the students (studentID only) who have taken either “PHY210” or “BIO001”.

Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20) LastName varchar(20) Gender char(1) DateofBirth date Courses Attribute Name Data Type CourseCode varchar(6) CourseName varchar(70) Level char(2) Credits int   Registration Attribute Name Data Type StudentID char(11) CourseCode varchar(6) Grade decimal(2, 1)   Write SQL code to:  1. Find the youngest student’s name. 2. How many students have NOT taken the course ‘CS056’? 3. Change the credit for all Computer Science courses (i.e. course codes CS***) with five credits from 5 to 6. 4. Delete the registration record for the student 908409-0010.

In SQL  This sample database consists of the following tables(see image for tables and there is one more at the bottom in this text):• Customers: stores customer’s data• Products: stores a list of scale model cars• ProductLines: stores a list of product line categories• Orders: stores sales orders placed by customers• OrderDetails: stores sales order line items for each sales order• Payments: stores payments made by customers based on their accounts• Employees: stores all employee information as well as the organization structuresuch as who reports to whom• Offices: stores sales office data Write SQL code for the following:We want to add a new sale order for the customer (customerNumber = 145) in thedatabase. The steps of adding a sale order are described as follows:(1) Get latest sale order number from “orders” table, and use the next sale ordernumber as the new sale order number(2) Insert a new sale order into “orders” table for the customer (customerNumber =145). For this order, the…

Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID             FNAME               LNAME               SALARY         JOIN_DATE              DEP_NO                     101                  John                  Abraham            10000                   01-JAN-13          11             202                  Michael                 Clarke                80000                  01-JAN-13          22            303                       Roy                   Thomas              70000                  01-FEB-13          11             404                     Tom                       Jose                  60000                   01-FEB-13          22             505                        Jerry                    Pinto                 65000                   01-FEB-13               22             606                    Philip                  Mathew              75000…