SQL is a programming language used by database developers to query data. You are required to write the SQL code when answering the following questions. Patient table PATIENTNUM NAME SURNAME APPOINTMENTDATE APPOINTMENTTIME SURGEONID W220 TONY JONES 12 JUNE 2016 10:00 S10011 W223 TSHEPO МОKENA 01 JULY 2016 09:00 S10011 W225 PERCY МАСKNA 12 JULY 2016 15:00 S10036 W224 JIMMY TAU 12 AUGUST 2016 14:00 S11006 Surgeon table SURGEONID NAME AGE SALARY S10011 ANA 35 12050 S10025 ANTONIO 45 90000 S10036 MARK 33 38000 S11006 МСCAIN 42 32500 Q.6.1 Write a SQL statement to create a Surgeon table. Q.6.2 Write a SQL statement that will display patient's name, appointment date and the appointment time and sorts only the column 'name' in ascending order. Q.6.3 Write a SQL statement that will display all surgeons that have salary less than 35000

SQL is a programming language used by database developers to query data. You are required to write the SQL code when answering the following questions. Patient table PATIENTNUM NAME SURNAME APPOINTMENTDATE APPOINTMENTTIME SURGEONID W220 TONY JONES 12 JUNE 2016 10:00 S10011 W223 TSHEPO МОKENA 01 JULY 2016 09:00 S10011 W225 PERCY МАСKNA 12 JULY 2016 15:00 S10036 W224 JIMMY TAU 12 AUGUST 2016 14:00 S11006 Surgeon table SURGEONID NAME AGE SALARY S10011 ANA 35 12050 S10025 ANTONIO 45 90000 S10036 MARK 33 38000 S11006 МСCAIN 42 32500 Q.6.1 Write a SQL statement to create a Surgeon table. Q.6.2 Write a SQL statement that will display patient's name, appointment date and the appointment time and sorts only the column 'name' in ascending order. Q.6.3 Write a SQL statement that will display all surgeons that have salary less than 35000

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

Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Task 9: Create the DELETE_INVOICE procedure to delete the invoice whose number is stored in I_INVOICE_NUM.
Function is given:-
can you slove more 3 queries
Which result set requires a JOIN? Showing all album titles with both artist ID and album ID Showing artist names with artist_id's Showing artist_id with album title Showing all album_id's with artist names
Task 5: Use the EXISTS operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021.
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
QUESTION 3 also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition. SELECT UNION INTERSECT DIFFERENCE
2
sql question Write an UPDATE statement that modifies the Customers table. Change the password column to “reset” for every customer in the table.