Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation year: expected year of graduation for the student "courses" table: course id: unique identifier for the course course name: name of the course instructor name: name of the instructor teaching the course. department: department offering the course. course description: description of the course "enrollments" table: enrollment id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in enrollment _date: date the student enrolled in the course orade: orade the student received in the course

Write a SQL query that retrieves the names and email addresses of all students who are enrolled in at least one course in the "Computer Science" department and have a graduation year of 2022 or later. Include the course name and instructor name for each enrollment in the output. Schemas of the tables are below. "students" table: student id: unique identifier for the student name: name of the student email: email address of the student major: field of study for the student graduation year: expected year of graduation for the student "courses" table: course id: unique identifier for the course course name: name of the course instructor name: name of the instructor teaching the course. department: department offering the course. course description: description of the course "enrollments" table: enrollment id: unique identifier for the enrollment student_id: identifier for the student enrolled in the course. course_id: identifier for the course the student is enrolled in enrollment _date: date the student enrolled in the course orade: orade the student received in the course

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

From the Salesm an and Customer tables below, write SQL statements to do the following: a) List the sales man id, rating and names of those sales men who getrating from 3 to 5, sorted DESCENDING by rating. b) List all the customers' informat ion whose name starts with 'F' and the fourth character is T, rests may be any charac ter. c) List the name andcountry of those customers and sales men who belongs to the same country. Salesman table: Salesman Salesman_ rating _id country name 2001 Mc Lyon 3 Italy 2005 James hood 2 Canada 2045 Paul Hen USA 2010 Nail Alex 4 France 2060 Salm E 5 KSA Cust omer table: Cust_id Cust_nam grade country Salesman e _id 1 Nick 100 France 2010 Rimando 2 Brad Davis 400 Canada 2005 3 Fabian 200 Japan 2045 Johnson 4 UK Jozy Altidor 100 2010 5 Brad Guzan 500 Canada 2005
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME BLOOD TYPE PCR TEST DOB GENDER PHONE FAX WEIGHT SMOKER 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT NVL2 (phone, fax, 0) FROM patients WHERE medical no = 1005; Answer:
SQL Language Please Just answer without explanation
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL_NO FIRST_NAME SUR_NAME DOB GENDER PHONE FAX BLOOD TYPE WEIGHT SMOKER PCR TEST 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male B 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male 91122544 AB Negative 66 YES 1005 Shamsa Alfahdi 15-Sep-2002 Female B 35 NO Negative SELECT INSTR(first name, 'h') FROM patients WHERE medical no = 1002; Answer:
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL_NO FIRST_NAME SUR_NAME DOB GENDER PHONE FAX BLOOD_TYPE WEIGHT SMOKER PCR_TEST 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 A. 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male B 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 Shamsa Alfahdi 15-Sep-2002 Female B 35 NO Negative SELECT CONCAT (SUBSTR(first_name, 1,2), weight) FROM patients WHERE blood_type= 'B' and weight > 70; Answer:
Write all the sql code (including create, insert and select)
QUICK SQL REQUEST (beginner level...) Back at work on Monday morning, the Vice President of Purchasing asks you to help him with the analysis of in-process storage. He asks you to pull information regarding the number of products per storage location. The result of the query should show: - The name of the warehouse (Location) - The number of different products per storage location - The total quantity of products found at this storage location - The average price of all products found at this storage location He mentions that for the moment he is only interested in the locations that have more than 50 distinct products because he wants to start inventorying the biggest locations first. Show the locations in order of smallest to largest number of distinct products. My request is linked to the question but i'm having trouble executing it I would love to know how to do it, thanks in advance.
By using this table answer this question in SQL: Show the department id, department name and the number of employees working in any department which has less than 4 employees
Need help writing SQL queries for sample data base
QUESTION 2. Write a PL/SQL PROCEDURE that can list the Top-N customers (id and name) and the amounts spent in a specified year together with their rank. The customer rank can be obtained from the function created in the previous question. The total purchase is calculated for each customer using the quantity and price columns. The total purchased is sorted from the highest to the lowest. The procedure will have two input parameters: year (NUMBER) and TOP_N (NUMBER). Hint: • use ONE EXPLICIT CURSOR (corresponding to one select statement). • Us the topN technique (from clause subquery) and rownum to limit the customers. Expected Output for Top 3 customers in 2018 using: execute topSpenders (2018. 3) 3 Gary Jenkins s422.64 Excellent 45 Fred Fontain $359.21 Excellent 16 Ralph Foster $351.64 Excellent Expected Output for Top 10 customers in 2018 using: begin topSpenders(2018,10 end: 3 Gary Jenkins s422.64 Excellent 45 Fred Fontain $359.21 Excellent 16 Ralph Foster $351.64 Excellent 81…
Write SQL code for the following: Create a stored procedure “setRelocationFee” to set the relocation fee for a givenemployee. If the employee’s office is in San Francisco, the relocation fee is $10000; ifthe employee’s office is in Boston, the relocation fee is $8000; if the employee’s officeis in London, the relocation fee is $20000; if the employee works in other offices, therelocation fee is $15000. (see image for table structure) I am stuck for the part that I have to select employeeNumber and officeCode and set the relocationFee to be able to obtain the result but I do not know how. Bellow is what I have gotten. Delimiter| CREATE PROCEDURE setRealocationFee(IN EmployeeID INT(11), OUT realocationFee INT(5))
Assume a database of Employees of a company have been given as shown below: Employee: Projects: Use SQL queries to find the followings: Find the average salary paid to the employees working in each project together with the project name. For each project, count the number of employees who are paid less than the average salary of that project. Find the name of the projects which have no employees assigned. Determine if there is any project with a budget less than the total salary paid to its employees. If yes, find the name of the project and its budget. The management wants to know which projects have been finished. Add an attribute to Projects table names status to show the current state of the project (Use SQL)