Database processing HW help

Database Access-MyWebSQL Web Page Web-based database access is available at this link. If you follow this link, the web page below will be displayed. Select the localhost MySQL as the database to access (it should be the default) and then login with the username 'student' and the password 'cis' (do not use quotes). e C Not serure serenity rider.du MyWebsQL Once you have logged in, the page below will be displayed. SQL queries can be typed in the bottom right frame with the tab labelled 'SQL Editor' (you have three different editor tabs available). Results will be displayed to the frame above the SQL editor. After you type your SQL query in the SQL Editor box, you execute the query using the Query button on the top right hand side of the SQL editor frame (circled in the screen capture image below). Note that this tool/program will automatically connect you to the correct database schema (dbclass). SQL Grouping Clauses and Functions Write the following SQL statements to query the NDX table in the dbclass schema/database. Your SQL statement should display only the columns identified unless otherwise specified. 1. Display the ChangeClose on the day Tuesday. 2. Display the average ChangeClose grouped by TYear, TQuarter. Show the TYear, TQuarter, and the average ChangeClose in that grouping Subqueries parts Column Data Type Description part_id part _name varchar int primary key name of part parts supplier Column part_id supplier id Data Type Description foreign key exported from parts table id of supplier who supplies the part 3. Write a SQL subquery which determines which records in the parts table have no related records in the parts suppliertable. 4. Write a SQL subquery which determines which records in the supplier table have no related records in the parts supplier table. 5. Write an outer join to retrieve records from the parts_supplier table and the parts table. This select statement should retrieve parts supplier table Database Access-MyWebSQL Web Page Web-based database access is available at this link. If you follow this link, the web page below will be displayed. Select the localhost MySQL as the database to access (it should be the default) and then login with the username 'student' and the password 'cis' (do not use quotes). e C Not serure serenity rider.du MyWebsQL Once you have logged in, the page below will be displayed. SQL queries can be typed in the bottom right frame with the tab labelled 'SQL Editor' (you have three different editor tabs available). Results will be displayed to the frame above the SQL editor. After you type your SQL query in the SQL Editor box, you execute the query using the Query button on the top right hand side of the SQL editor frame (circled in the screen capture image below). Note that this tool/program will automatically connect you to the correct database schema (dbclass). SQL Grouping Clauses and Functions Write the following SQL statements to query the NDX table in the dbclass schema/database. Your SQL statement should display only the columns identified unless otherwise specified. 1. Display the ChangeClose on the day Tuesday. 2. Display the average ChangeClose grouped by TYear, TQuarter. Show the TYear, TQuarter, and the average ChangeClose in that grouping Subqueries parts Column Data Type Description part_id part _name varchar int primary key name of part parts supplier Column part_id supplier id Data Type Description foreign key exported from parts table id of supplier who supplies the part 3. Write a SQL subquery which determines which records in the parts table have no related records in the parts suppliertable. 4. Write a SQL subquery which determines which records in the supplier table have no related records in the parts supplier table. 5. Write an outer join to retrieve records from the parts_supplier table and the parts table. This select statement should retrieve parts supplier table