1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row c. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item sale_price Full_price 25 Apple NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows

1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row c. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item sale_price Full_price 25 Apple NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter8: Sql Functions And Procedures

Section: Chapter Questions

Problem 9CAT

See similar textbooks

Similar questions

INFO 2303 Database Programing Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a function that takes patient date of birth. If the patient born after 30th June 1990 then he/she will be required to set appointment for immunization. Call this function from anonymous block to allow the user to enter the patient ID. Expected output: Enter the patient ID: 168 The status of X-immunization : REQUIRED
a) Write a SAS SQL statement to retrieve all columns fromPG1.STORM_FINAL.(b) Modify the query to retrieve only the Season, Name, StartDate, andMaxWindMPH columns. Format StartDate with MMDDYY10.(c) Modify Name in the clause to convert the values to proper case.(d) Add a clause to include storms during or after the 2000 season withMaxWindMPH greater than 156.(e) Add a clause to arrange rows by descending MaxWindMPH, and then byName.(f) Add a proper statements to describe the report.
Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. 1. Write an anonymous block to retrieve the doctor’s ID and name which in charge of certain patient. Allow the user to enter the patient’s ID. 2. Write an anonymous PL/SQL block that will insert a new doctor into the DOCTOR table. Verify that insert has been done successfully by issuing a select * from doctor. 3. Write an anonymous PL/SQL block that will update the salary of all doctors in the Pediatrics area by 1000 (Note: Current salary + 1000). Verify that the salary has been updated by issuing a select * from doctor where area = ‘Pediatrics’. You may have to run the select statement twice to check the data before and after the update. 4. Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice area. Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’.…
31-Create a SQL statement to Display the number of clients for each CType with having less than 2 clients in the CLIENTS table.
1. Write SQL retrieval commands for each of the following queries:a. Display the course ID and course name for all courses with an MC prefix.b. Display all courses for which Professor Newton has been qualified.c. Display the class roster, including student name, for all students enrolled in section 1003 of MC123 and section 1005 of MC222.2. Write an SQL query to answer the following question: Which instructors are qualified to teach MS211 and MS111?3. Write an SQL query to answer the following question: Is any instructor qualified to teach MS111 and not qualified to teach MS232?4. Write SQL queries to answer the following questions: How many students were enrolled in section 1003 during semester I-2021?5. How many students were enrolled in MS232 during semester I-2021?6. Write an SQL query to answer the following question: Which students were not enrolled in any courses during semester 1-2021?
Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write an anonymous PL/SQL block that will insert a new doctor into the DOCTOR Verify that insert has been done successfully by issuing a select * from doctor.
I need SQL code for the following question: - Use MYSQL for coding Create a MySQL table named 'prime_test' that contains two columns. The first column is an integer named 'number' that is the primary key and cannot be NULL. The second column is a variable length string named 'is_prime' with a maximum length of 50. Write one or more insert statements that fills only the 'number' column of table 'prime_test' with the integers between 2 and 100. Write one or more update statements that sets the 'is_prime' column for each associated integer. For a prime, the column should read 'prime'. For non-primes, the column should read 'composite'. Write a final select statement to return only the 'number' column from 'prime_test' for records that are prime, ordered from largest to smallest.
Create a function name BALANCE that returns the status of outstanding amount for each customer. Use the following criteria for your function: Outstanding_amt less than 5000 , returns ‘SMALL AMOUNT’ Outstanding_amt between 5000 and 10000 , returns ‘AVERAGE AMOUNT’ Outstanding_amt greater than 10000 , returns ‘LARGE AMOUNT’ Use function BALANCE in your SQL statements that display the cust_code, cust_name, Outstanding_amt and function BALANCE.
SQL QUERIES Employees(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)Department(DEPARTMENT_ID,DEPARTMENT_NAME,MANAGER_ID,LOCATION_ID)A: Write a query in SQL to display the minimum, maximum salary and DEPARTMENT_ID of all thosedepartments whose minimum salary is greater than 4000 in ascending order. B: Write a Query in SQL to display characters only from 2 to 5 of “Last_Name” from Employees table. C: Write a query in SQL to display the HIRE_DATE of every employee in following format.Format: 11-july-2019
This does not work: CREATE OR REPLACE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW BEGIN 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; END; I get the following error: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW BEGIN UPDATE AIRCRAF' at line 1 Here is the original question: 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.)
SQL- StayWell’s maintenance team is working on the staffing plan for the month of November 2019 including number of people required in the upcoming month. They need all the service requests with the category of Plumbing (category number 1) and Heating (category number 2), and the next service date within November 2019. You need to collect this information from service requests and send it to the team. To use BETWEEN condition with dates, do not forget to use the CAST function to convert the values to dates such as CAST('2019-01-01' AS DATE).
SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql Part I: Problem 1. Write a stored procedure that adds a new employee to lgemployee table. Pass the field values to the procedure as parameters. Problem 2. Use parameters and a DECLARE statement to display employees that were hired in every decade beginning 1970. The program should return the statements similar to this: 12 employees were hired between 1970 and 198019 employees were hired between 1980 and 1990etc. Part II: Problem 1. Write a cursor to print a report for each employee’s salary history. Display employee’s number, last and first name, and the salary with the starting date. Problem 2. Modify the previous problem code to make it a stored procedure that accepts employee’s last name as

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS