do the lab, project and the 25 questions multiple choice in 35 min

Write 10 SQL statements against the STUDENT schema. Your statements should run error-free and should be valid. Submit two separate files: one plain text file (.txt or .sql file) with your statements only; and the other document (doc/docx/pdf) include both your statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document.Q1. List all instructors. Show salutation in all lower cases, last name in all upper cases and phone number in the format of '(xxx) xxx-xxxx'. (HINT: use LOWER, UPPER and SUBSTR function)Q2. List all students (display student_id, first name, last name, street address, zipcode, city, and state) who live in New York, NY. Sort results by last name, and then first name, in descending order.Q3. Display the city in which each instructor lives. List first name, last name, zip, city, and state. Display "N/A" for zip, city, and state if an instructor does not have a zipcode. (HINT: left join INSTRUCTOR and ZIPCODE; use NVL function)Q4. Show the number of instructors who live in NY state and has a street number of 518. (HINT: use string functions such as SUBSTR and INSTR)Q5. Display the lowest, highest, and average numeric grade of Project grade type. (HINT: use the MIN, MAX, and AVG function; join GRADE and GRADE_TYPE)-- LEFT JOIN, DATEQ6. List all students (display student_id, first name, last name, and registration date) who registered on or before 2/15/2007 but have not enrolled in any course. (HINT: left outer join STUDENT and ENROLLMENT; use the TO_DATE function)-- COUNT WITH 3-TABLE JOINQ7. Find how many students are enrolled in sections taught by Todd Smythe. (HINT: join INSTRUCTOR, SECTION, and ENROLLMENT)-- 4-TABLE JOINQ8. Show all students who are taking, or have taken the course "Advanced Java Programming course". List student name, enrollment date, and section location. (HINT: join COURSE, SECTION, ENROLLMENT, and STUDENT)-- 4-TABLE JOINQ9. List the students who have received any numeric grade score of at least 95 in an Advanced Java Programming course. Show student name, the grade type code, and the numeric grade.-- 4-TABLE JOIN WITH DISTINCTQ10. List the instructors who teach Advanced Java Programming (having a section with students enrolled), without duplication. Show instructor name and course name. (HINT: use the DISTINCT keyword)Learning Resourceshttps://www.w3schools.com/sql/sql_join.asphttps://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006

Before beginning this interactive assignment, complete the Practice Labs exercise in your online classroom, and review this week’s lecture and reading materials. In this task, you will examine the various sources of data available for analysis and use in charts and graphs. Using the scenario or business problem you described in last week’s interactive discussion, identify, and obtain data that can be used to create graphs and charts to supplement your scenario (e.g., by providing additional decision-making capacity or related information). You may use your own source or use the following site for publicly available data sets for use in R: https://github.com/vincentarelbundock/Rdatasets.In your initial post, describe your scenario, and explain how this data can be used to support decision-making in your example. Provide an example of a decision that could be made in your scenario with data you have recently identified—the example can consist of a narrative or a screen capture of an explanatory graph or chart. Be sure to identify the source/site where the data was obtained so your peers may examine the raw data you will use for your scenario’s enhanced decision-making.use the link for https://www.tutorialspoint.com/r/r_decision_tree.h...