NEED HELP IN MY SQL WHAT IS THE COMMAND LINE (CMD) STATEMENT FOR THE QUERY IN NUMBER 4 (2ND PICTURE)I REPEAT,WHAT IS THE CMD QUERY FOR THE 4 (a,b,c,d,e) IN NUMBER 4 1. Create a database UAAP.2. Create the following tables on the database that you created.Field NameTeamIDTeamNameField NameGameIDWinTeamIDLooseTeamIDWScoreLScoreLocation IDGameDateTeamID12345678LocationID123TeamTeamData TypeInt(3), unsigned, Auto_Increment,Primary Key, not nullvarchar(50), not null3. Insert the following data on each table you created.Game PlayData TypeInt(3), unsigned, Auto_Increment, Primary Keynot nullTeamNameAteneo Blue EaglesLa Salle Green ArchersUST Growling TigersFEU TamarawsUP Fighting MaroonsUE Red WarriorsLocationAdamson FalconsNU BulldogsInt, not nullInt, not nullInt, not nullInt, not nullInt, not nullDate, not nullLocationNameAraneta ColiseumCuneta AstrodomeMOA ArenaRefereelD123456GamelD123456RefereeNameGil BautistaRey SanchezBrando FerrerIsmael MansolTeofilo OfreJaime RanitoWinTeamID153253Page 2/ 26871Field NameRefereelDRefereeBirthdate1983-08-301980-11-081987-09-151977-10-311972-11-201992-11-02Game PlayLooseTeamID WScore49810276851168996852RefereeNameBirthdateAgeAddressField NameLocationIDLocationNameData TypeInt (3), unsigned, Auto_Increment,Primary Key, not nullVarchar(50), noy nullDate, not nullReferee+Data TypeInt(3), unsigned, Auto_Increment,Primary Key not nullvarchar(30), not nullAge343730404525LScore92767480997401Location76Int(3), not nullVarchar(50), not nullAddressLuzonVisayasLuzonLuzonMindanaoVisayasLocation ID12231313GameDate2017-11-152017-11-202017-11-252017-12-152017-12-202018-01-052018-01-102018-01-15 4. Create a SQL statement of the following,a. Show the gameid and gamedate of the game that were played in Araneta Coliseum or MOA Arena.b. Show the name, age, and birth date of the referee who were born in 1980's and 1990's.c. Show the name and address of the referee who lives in Visayas and Mindanao.d. Show winteamid, looseteamid, locationid and gamedate of the games that was played lastNovember 2017.e. Show all the details of the referee whose age is from 30 to 40 years old.

SELECT command of Structured Query Language is implemented to extract the information which is…

4. Create a SQL statement of the following; a. Show the gameid and gamedate of the game that were played in Araneta Coliseum or MOA Arena. b. Show the name, age, and birth date of the referee who were born in 1980's and 1990's. c. Show the name and address of the referee who lives in Visayas and Mindanao. d. Show winteamid, looseteamid, locationid and gamedate of the games that was played last November 2017. e. Show all the details of the referee whose age is from 30 to 40 years old.

4. Create a SQL statement of the following; a. Show the gameid and gamedate of the game that were played in Araneta Coliseum or MOA Arena. b. Show the name, age, and birth date of the referee who were born in 1980's and 1990's. c. Show the name and address of the referee who lives in Visayas and Mindanao. d. Show winteamid, looseteamid, locationid and gamedate of the games that was played last November 2017. e. Show all the details of the referee whose age is from 30 to 40 years old.

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

Write a PL/SQL using a cursor with Basic loop to update the Price attribute of all flight records inFlight table according to the following conditions: 1- If the FName is Oman Air, change price to 500.2-If the FName is Emirates, change price to 200.3- If the FName is Air India, change price to 250.
Part 2: PL/SQL By using PL/SQL create the following: 1- A procedure Proc_Insert(arg2,arg3..argn): When the procedure is executed, the value of the passed arguments will be inserted into a table of your database.Note(you have to use one of the created Sequences to generate a value to be inserted into a field of your table). 2- A Procedure Update_value(arg1,arg2): The procedure searches about arg1 value in a specific column of your table and changes the value of the searched item to be equals arg2. 3- A procedure called del_Record_from_Table(arg1) that deletes a specific row from one of the tables you created. 4- A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. 5- A row type trigger that's fires to accept the deleted rows from a table on your database and store them into another table. -You must create a new table to accept the deleted rows. - The new table must contain two additional columns, the first…
Please use MySQL language and mySQL as server
What are the performance implications of heavily nesting SQL functions within a query?
Write any five PL/SQL programs.
Describe any 2 Special Operators in SQL with an example for each operator showing how it is used in SQL statement.
SQL based question
Explain NVL, NVL2, Round, trim, to_char in sql.
Proper explanation else skip it
how do you use PL/SQL or T-SQL procedures in SQL?
on this table CREATE TABLE students ( std_id int NOT NULL PRIMARY KEY, f_name VARCHAR2(20), l_name VARCHAR2(20), std_address VARCHAR2(50), tel_no VARCHAR2(15), SEX VARCHAR2(10), birthdate date ); use PL/SQL oracle to solve create A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. arg is int all data are int and varchar2 and date