1. Write SQL statements to create the tables below.2. Write SQL statements to insert at least 5 rows / records into each table.3. Write SQL to display the average Read for all students.4. Write SQL to display the number of students assigned to each Tutor and Tutor Status5. Write SQL to display for each match the duration of assignement and certification date for tutorand Read Score.TUTOR (TutorID, CertDate, Status)TuturIDCertDateStatus1001/05/2008Active1/05/20081/05/2008101Temp StopDropped1025/22/20085/22/20085/22/20085/22/2008103Active104ActiveTemp Stop105106ActiveSTUDENT (StudentID, Read)StudentIDRead30002.330015.630021.330033.330042.730054.830067.830071.5MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate)MatchIDTutorIDStudentIDStartDateEndDate10030001/10/20081/15/20085/15/20083/01/2008210130012/10/20085/28/200810230024106300310330046/01/20086/15/20086/01/20086/01/200810430056/28/200871043006c0 00

Create table : Tutor table CREATE TABLE TUTOR ( TutorId int NOT NULL, CertDate date, Status…

1. Write SQL statements to create the tables below. 2. Write SQL statements to insert at least 5 rows / records into each table. 3. Write SQL to display the average Read for all students. 4. Write SQL to display the number of students assigned to each Tutor and Tutor Status 5. Write SQL to display for each match the duration of assignement and certification date for tutor and Read Score. TUTOR (TutorID, CertDate, Status) TuturID CertDate Status 100 1/05/2008 Active 1/05/2008 1/05/2008 5/22/2008 5/22/2008 5/22/2008 101 Temp Stop Dropped Active Active 102 103 104 105 Temp Stop 106 5/22/2008 Active STUDENT (StudentiD, Read) StudentID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 3005 4.8 3006 7.8 3007 1.5 MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) MatchID TutorID StudentID StartDate EndDate 100 3000 1/10/2008 3001 1/15/2008 5/15/2008 2 101 2/10/2008 5/28/2008 3 102 3002 3/01/2008 106 3003 6/01/2008 6/01/2008 6/15/2008 6/28/2008 103 3004 6. 104 3005 104 3006 6/01/2008

1. Write SQL statements to create the tables below. 2. Write SQL statements to insert at least 5 rows / records into each table. 3. Write SQL to display the average Read for all students. 4. Write SQL to display the number of students assigned to each Tutor and Tutor Status 5. Write SQL to display for each match the duration of assignement and certification date for tutor and Read Score. TUTOR (TutorID, CertDate, Status) TuturID CertDate Status 100 1/05/2008 Active 1/05/2008 1/05/2008 5/22/2008 5/22/2008 5/22/2008 101 Temp Stop Dropped Active Active 102 103 104 105 Temp Stop 106 5/22/2008 Active STUDENT (StudentiD, Read) StudentID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 3005 4.8 3006 7.8 3007 1.5 MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) MatchID TutorID StudentID StartDate EndDate 100 3000 1/10/2008 3001 1/15/2008 5/15/2008 2 101 2/10/2008 5/28/2008 3 102 3002 3/01/2008 106 3003 6/01/2008 6/01/2008 6/15/2008 6/28/2008 103 3004 6. 104 3005 104 3006 6/01/2008

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Convert the following statements into SQL queries. 1) i want to retrieve all records from a table student. 2) i want to retrieve all record from a table "student" who have marks greater than 80. 3) i want to delete all records from a table "student"
last 3 subparts
in sql The ALTER SEQUENCE statement can be used to: Select one: a. Change the maximum value to a lower number than was last used b. Change the name of the sequence c. Change the START WITH value of a sequence d. Change the amount a sequence increments each time a number is generated
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
Database
Database: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
Oracle SQL a---Write a query to display order number, customer number, order date and items ordered for some customer and Make Sure provide the result output: b---Write a query to display each item ordered for order #1, its standard price, and total price for each item ordered and Make sure provide the result output. c---Write your own query to display some data – Make sure describe what you are trying to display and write your query with the result.
example inn 100 sqlmstatement
SQL procedure a. Write a procedure in SQL that inserts a new customer record into the "Customers" table. b. Create a procedure that updates the quantity of a product in the "Inventory" table based on the product ID. c. Write a procedure that calculates the average salary of all employees in the "Employees" table and displays the result.
7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure eachdifferent length value is displayed only once (not once for each book). SQL commands
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
31 Refer to the given SQL statement. SELECT PRODNUM, PRODNAME FROM PRODUCT: Which line designates a product number of at least 300 when added to the end of this statement? O WHERE PRODNUM>=300 WHERE PRODNUM=300+ O WHERE PRODNUM=(300; unlimited) WHERE PRODNUM=>300