(b) Consider the schema of Customer table and write SQL statements for the following queries.i.Using SQL, write the command to insert the values in the Client table.sidsnameaddressageoccupationsalaryRavment mode gender123samxacoas31manager60000cash124davidflaca38administrator 45000creditm00000ii.Write the SQL query to display the cid of all employees.iii.Write the SQL code to list all administrators whose salary is greater than Rs 45000.

i. Using SQL, write the command to insert the values in the Client table. sid Sname address age occupation salary Payment mode gender 123 Sam yacoas 31 manager 60000 cash 124 david flaca 38 administrator 45000 credit m ii. Write the SQL query to display the cid of all employees. iii. Write the SQL code to list all administrators whose salary is greater than Rs 45000.

i. Using SQL, write the command to insert the values in the Client table. sid Sname address age occupation salary Payment mode gender 123 Sam yacoas 31 manager 60000 cash 124 david flaca 38 administrator 45000 credit m ii. Write the SQL query to display the cid of all employees. iii. Write the SQL code to list all administrators whose salary is greater than Rs 45000.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

Write the SQL code to delete the row for William Smithfield, who was hired on June 22, 2004, and whose job code is 500. (Hint: Use logical operators to include all of the information given in this problem.)
Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT. b.Copy the matching EMP_2 values into the TEMP_1 table.
(a) Write the sql syntax to create a table name customer with the following restrictions;Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname and occupation do not accept null values.Payment_mode accepts only cash or credit entries.The default address is “Flacq”.customer is at least 18 years old.Salary is above Rs 25000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). ii. Write the SQL query to display the cid and gender of all employees. iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000. iv. Write the SQL query to set the salary of all administrators to Rs 50 000. v. write the SQL query to display details of customers whose names start with character 'e'. vi. Write the SQL code…
(a) Write the sql syntax to create a table name customer with the following restrictions;Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname and occupation do not accept null values.Payment_mode accepts only cash or credit entries.The default address is “Flacq”.customer is at least 18 years old.Salary is above Rs 25000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). ii. Write the SQL query to display the cid and gender of all employees.iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000.
Provide all the SQL statements that are required for the following transactions to be executed. Transaction 01: A residential customer (Bob Builder) of 53 Drip Drive, Dripwater (post code: 1267) has an account with the water company at the same address. The meter was installed on 30th October 2019 and has the serial number DDWC4763. This customer does not have any outstanding balance for the service at this address. Transaction 02: On 23rd July, 2020, the meter at 53 Drip Drive, Dripwater was read by Karen Karpenter (a meter reader). The reading the last time this meter was read was 123580 kL, at this reading it was 123683 kL. The bill was created and sent on the same day. Transaction 03: On 2nd August 2020, Bob Builder settled the account in full for consumption at 53 Drip Drive, Dripwater using PayPal.
(a) What SQL statement would you use to create the table ”staff”, including specifying the primary key? (b) What SQL statement would you use to find out how many lecturers there are in the School of Computing? (c) What SQL statement would you use to list the lecturers of the modules COMP1121 and COMP1211? (d) Write an SQL statement, using the inner join construct, that will, for the lecturer John Smith, list in alphabetical order the students taking any module which he teaches. (e) What information does the output from the following SQL query provide? SELECT Lecturer, COUNT(DISTINCT Student) FROM class INNER JOIN staff ON class.Module = staff.Module WHERE Grade < 40 GROUP BY Lecturer; (f) Write an SQL query which would obtain the following information: for each lecturer, what is the average grade obtained by students across all of the modules which they have taught?
Given the following relation: Movie (MovieID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: Read a movie id provided by user at run time and store it in a variable. Fetch the Genre and title of the movie having the entered id and store them inside two variables Display the fetched movie Genre and title.
This is a database system question regarding SELECT: Which of the following statements is true for SELECT statements in general? a. HAVING is executed before WHERE when running an SQL query b. SELECT is executed before FROM when running an SQL query c. Each SELECT clause must have a WHERE clause as well. d. COUNT(column_name) function returns the number of values in the column, including any NULLs e. HAVING clause specifies a condition for selecting grouped tuples from the GROUP BY clause.

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS