Please do NOT answer the question, just tell me what I would put in the SQL querey for each question based on the table in blue. It should go something like SELECTFROMWHERE for each, but I am not sure what to put for each one Employee (empNo, firstName, lastName, address, DOB, sex, position, deptNo)Department (deptNo, deptName, mgrEmpNo)Project (projNo, projName, deptNo)WorksOn (empNo, projNo, hoursWorked)Dependent (empNo, Dependent name, Sex, Bdate, Relationship)NOTE 1: You can try the query on Azure Data Studio (Login Open a new Query? UseEmployee Database;)NOTE 2: An employee always belongs to a single department. However, she/he can work forprojects originating from other departments too.1. Write a SQL query to list the WorksOn records for all employees, in the descending order ofnot only the projects but also the number of hours worked?2.IProvide the complete details of employees who were born before 1970? (Hint: the dates needto be enclosed inside single quotes - e.g., '1999-12-31')3. List all the details of the projects that are from department "IT Transformation" and list theprojects in the reverse alphabetical order of project names (Hint: The list of departmentnames can be found in "Department" table)4. List the unique project numbers that have employees Working On those projects for 10, 14,18, 22, 27.5, 33 or 36 hours in a week. (Hint: Use the keyword IN.)

SQL: SQL stands for Structuted Query Language. It is used to access and manipulate database. It is…

Please do NOT answer the question, just tell me what I would put in the SQL querey for each question based on the table in blue. It should go something like SELECT FROM WHERE for each, but I am not sure what to put for each one

Please do NOT answer the question, just tell me what I would put in the SQL querey for each question based on the table in blue. It should go something like SELECT FROM WHERE for each, but I am not sure what to put for each one

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 2.7CP

See similar textbooks

Similar questions

3.9 LAB - Select lesson schedule with inner join The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.
GOCREATE TABLE dbo.booth(booth_Product char(25) ,booth_Price money);CREATE TABLE dbo.machine(machine_product char(25) ,machine_price money);GOCREATE TABLE dbo.product(product_id int not null,product_description varchar(30) not null ,PRIMARY KEY (product_id)); THis is one way to create a table; but you can also can also right click on databases and then newdatabase is one prefered over the other?
Task 2: The InstantRide Driver Relationship team wants to check if there are any drivers with zero rides. You need to extract the DRIVER_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME of the drivers with zero rides. You can use a subquery with DRIVER_ID compared to ALL rows in TRAVELS. Task: Check if any drivers have given zero rides.
CREATE TABLE sales ( SalesNumber INT(10) AUTO_INCREMENT PRIMARY KEY, SalesDate DATE, SalesTotal DECIMAL(10,2)); CREATE TABLE products ( number INT(11) AUTO_INCREMENT PRIMARY KEY, prodid VARCHAR(20) UNIQUE, prodname VARCHAR(30), price DECIMAL(10,2), onhand INT(11), CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES salesdetails(prodid) ON DELETE RESTRICT); CREATE TABLE salesdetails ( number INT(10) AUTO_INCREMENT PRIMARY KEY, SalesNumber INT(10), prodid VARCHAR(20), price DECIMAL(7,2), qty INT(10), CONSTRAINT fk_salesdetails_sales FOREIGN KEY (SalesNumber) REFERENCES sales(SalesNumber) ON DELETE CASCADE, CONSTRAINT fk_salesdetails_products FOREIGN KEY (prodid) REFERENCES products(prodid) ON DELETE CASCADE); Using the above SQL and the schema diagram, create an ER diagram detailing all the fields of the tables and the relationship amount the tables.
There's a "users" table that has more than 1M rows of "users" information. The image below are the first 3 rows.Implement a SQL query that retrieves the "email" and "friend_count" of the "user_id" with the most friends.
Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that lists the titles of films with the fewest rows in the inventory table. This query requires a subquery that computes the minimum of counts by film_id: SELECT MIN(count_film_id) FROM ( SELECT COUNT(film_id) AS count_film_id FROM inventory GROUP BY film_id ) AS temp_table; This subquery is provided in the template.
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results.
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.
The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs
Textbook: Digital Systems Chapter 8 Question/Problem 44 I'm not sure if I'm running the correct Query for this problem. The question is: "Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)" I ran this query without any errors: CREATE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW UPDATE AIRCRAFT SET AC_TTAF = AC_TTAF + NEW.CHAR_HOURS_FLOWN, AC_TTEL = AC_TTEL + NEW.CHAR_HOURS_FLOWN, AC_TTER = AC_TTER + NEW.CHAR_HOURS_FLOWN WHERE AIRCRAFT.AC_NUMBER = NEW.AC_NUMBER; But the answer is still incorrect because the last row doesn't have the expected values. I'm not sure why the test query would delete any row with a CHAR_TRIP ABOVE 10018. I attached a screen of the output I'm getting: I saw in another answer this:…
Textbook: Digital Systems Chapter 8 Question/Problem 44 I'm not sure if I'm running the correct Query for this problem. The question is: "Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)" I ran this query without any errors: CREATE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW UPDATE AIRCRAFT SET AC_TTAF = AC_TTAF + NEW.CHAR_HOURS_FLOWN, AC_TTEL = AC_TTEL + NEW.CHAR_HOURS_FLOWN, AC_TTER = AC_TTER + NEW.CHAR_HOURS_FLOWN WHERE AIRCRAFT.AC_NUMBER = NEW.AC_NUMBER; But the answer is still incorrect because the last row doesn't have the expected values. I'm not sure why the test query would delete any row with a CHAR_TRIP ABOVE 10018. I attached a screen of the output I'm getting:
USing sakila SELECT last_name, first_name, ROUND(AVG(length), 0) AS averageFROM actorINNER JOIN film_actor ON film_actor.actor_id = actor.actor_idINNER JOIN film ON film_actor.film_id = film.film_idWHERE title = "ALONE TRIP"GROUP BY last_name, first_nameORDER BY average;Highlight the SELECT query.In the main menu, select Query > Explain Current Statement.In the Display Info box, highlighted in red below, select Data Read per Join. The execution plan depicts the result of EXPLAIN for the SELECT query. The execution plan has seven steps, corresponding to the red numbers on the screenshot: Access a single film row using the idx_title index on the title column. Access matching film_actor rows using the idx_fk_film_id index on the film_id foreign key. Join the results using the nested loop algorithm. Access actor rows via the index on the primary key. Join actor rows with the prior join result using the nested loop algorithm. Store the result in a temporary table and compute the…