(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.

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

1. Produce a list of all customer names in which the first letter of the first and last names is inuppercase and the rest are in lowercase. SQL commands
Please help: Using the following sql file, how would you find List all the rows in which the prescription dates occur on or after November 14. How many doctors provide prescriptions with 30 tablets in total? List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order Find all patients rows whose first names include ‘George’ (Assume case sensitivity). List number of patients that do not have a phone number. Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End; //* Assignment_1 */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
4) Display the firstname, lastname of the employees and the customerID that the employee served. Arrange the results by the last name. 5) Write a query to the Name of the Product and the corresponding name of the supplier of that Product for all the products that start with a “P”. 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) I need help figuring out the SQL quereys for the questions above using table joining method
code BANK branches N ACCOUNT loanNo enrolls CUSTOMER phone address name Q1. Transform the ERD above to its corresponding Relational Schema. Q2. Using the transform ERD, Write appropriate SQL DDL statement to define the database. Q3. Specify the following queries in SQL. a.) Retrieve all account numbers with balance greater than 100,000. b.) Retrieve the bank name, branch name and account number of each customer account. c.) Find the average loan per branch. Q4. Write SQL update statements to do the following. a.) Insert new customer Manuel Cruz, with social security number of 987-65-4320 who lives at Iligan City and a contact number of 09170000001 b.) Marie Sanchez's loan amount was increased by 15,000. c.) Sergio Ramos opened a checking account with a minimum balance of 150,000 d.) Remove the account record with account number 262262100 name address accountNo SSN M N N offers balance address type N BRANCH loans M applies N branch No LOAN amount type
Task 3: The InstantRide Finance team wants to collect the price and discount information with the driver names for each travel in the system. You need to return the TRAVEL_ID, DRIVER_FIRST_NAME, DRIVER_LAST_NAME, TRAVEL_PRICE, and TRAVEL_DISCOUNT information from the TRAVELS and DRIVERS tables combined over DRIVER_ID field with the ON keyword. Task: Calculate each user's price and discount information. (SQL Database Test)
SQL Server Please help answer question 5 Please type out the answer because I cannot read the last answer because the handwriting is not very clear. Thank you.
7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure eachdifferent length value is displayed only once (not once for each book). SQL commands
SQL: For every invoice, display the invoice number, invoice date and the total dollar amount for all products purchased in the invoice, ordered by invoice number in descending order and then by invoice date in ascending order. Here you will use an aggregate SUM(x,y) function in your SELECT clause to calculate the total dollar amount (a calculated field – name it TOTAL). Don’t forget to join on the tables as well. [hint: you should have 8 rows of output ordered properly]. select inv_number, inv_date sum(list_price) as 'total' from invoice, line order by desc inv_num, asc inv_date. I am getting the error: ORA-00923: FROM keyword not found where expected Am I formulating the query incorrectly?
For SQL, Modify the following select statement. Convert the datatypes of all the columns to text. (Actually, sometimes this code will work as it is and the conversion of the datatypes is done automatically for you behind the scenes.)select date_1, date_1, date_1from sec1507_firstunionselect number_2, word_2, date_2from sec1507_second;
create a PL/SQL code to determine which employee works for which city and report their increase based on the city. when employee is in city A ,salary lower then 10000, tey will get 10%more salary in city b ,salary lower then 10000, they will get 15%more salary all others ,they will only get 5% more . how to do this ? display salary , increased salary .salary in one year , first_name last_name ,emp id and city SELECT employee_id, salary, salary*12 , city From employees JOIN departments
Create the SQL code that will calculate the total number of hours worked and the total amount of money charged by all employees.
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing