Use the following table to find the OUTPUT of the following SQL queries:Table Name: PatientsMEDICAL NOFIRST NAMESUR NAMEBLOOD TYPEPCR TESTDOBGENDERPHONEFAXWEIGHTSMOKER1001SaidAlalawi12-Jun-2001Male9887744522114454A68NONegative1002OthmanMualla20-Apr-2000Male78YESPositive1003SameeraBader19-Oct-2005Female2554112252NOPositive1004FahadAlhinai24-Feb-2004Male91122544AB66YESNegative1005shamsaAlfahdi15-Sep-2002Female35NONegativeSELECT NVL2 (phone, fax, 0)FROM patientsWHERE medical no= 1005;Answer:

NVL2(expr1, expr2, expr3) : The NVL2 function examines the first expression. If the first expression…

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-lun-2001 Male 98877445 22114454 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 VES 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:

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-lun-2001 Male 98877445 22114454 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 VES 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:

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

using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount
Use the following tables to write the SQL queries: Table Name: Employees EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 105 David 02/21/2018 IT PROG 4800 60 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500 1600 50090 South Brunswick US 1700 98199 Seattle US 60 IT 1400 1800 M5V 2L7 Toronto CA 90 Executive 1700 1900 YSW 9T2 Whitehorse CA 100 Finance 1700 1.Write SQL Command to, display employee id and job id who gets salary within the range of 4000…
Write the SQL Code for Select the names of wicketkeeper along with the number of sixes that they have hit (while batting) ? table is in the pic
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
Use the following tables to write the SQL queries: Table Name: Employees EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 105 David 02/21/2018 IT PROG 4800 60 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500 1600 South Brunswick 50090 US 1700 98199 Seattle US 60 IT 1400 1800 M5V 2L7 Toronto CA 90 Executive 1700 1900 YSW 9T2 Whitehorse CA 100 Finance 1700 Write SQL Command to display employee first name , department name for all employees whose job id…
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
Use the following tables to write the SQL queries: Table Name: Employees Write SQL Command to display employee first name , salary and new column called Degree. Evaluate the new column data based on the following EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 02/21/2018 conditions: 105 David IT PROG 4800 60 If salary is more than 20000 then Degree is PHD If salary is more than 10000 then Degree is 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL_CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500…
Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com | 2010-06-18 Irfan@abc.com Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
Write two SQL Queries that will show the ORDER# from both the Orderand OrderItems table using the UNION set operator
SQL Database Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER_NUM
8) Display the firstname, lastname of the employees and the customerID that the employee served such that the employees are born after '1960-01-01'. Arrange the results by the last name. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY) NOTE: Please use only table joining to write the SQL quereys.