1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS.2. Write an SQL query to change the LOCATION of CUSTOMER as “BARKA" and who's quantity is LESSthan 1000.3. Write an SQL query to display all information from items table and display orders delivered in the month ofJune.4. Write an SQL query to determine the Maximum price, Minimum price and count the items. Rename the outputas Max price Min price. Neitems respectively.5. Write an SQL query to display the month (in alphabets) and date when the orders are delivered to theCUSTOMERS.6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is greater than 30000.7. Write an SQL query to display and find the total amount using the columns PRICE and QUANTITY and createan alias as "Total Amount" for this calculation. (Total Amount = Price * Quantity). (Use Item andCustomer Details).8. Write an SQL Query to determine the months between CURRENTDATE and DELIVERY_DATE.9. Write an SQL query to find the number of weeks between DELIVERY_DATE and CURRENTDATE andwhose MANUFACTURER NAME having the character with 'E'. (Use Item and CustomerDetails).10. Write an SQL query to extract the first three characters of CUSTOMERNAME and the last three characters ofMANUFACTURER NAMES. (Use Item and Customer Details) Table Name : ItemColumn nameDatatypeVarchar2Varchar2Varchar2NumberSizeConstraintIDPrimary keyITEM NAMEMANUFACTURERPRICE|DELIVERY DATE8308.Not NullDateTable Name : Customer DetailsColumn nameConstraintDatatypeVarchar2SizeIDForeign KeyVarchar2Varchar2CUSTOMERNAME30LOCATION30CUSTOMERIDVarchar28QUANTITYNumber8Data for Item tableIDITEMNAME MANUFACTURER | PRICE DELIVERY DATE09001COMPUTERDELL3500012-June-200409002 | KEYBOARD INTEX1000025-June-200409003 COMPUTER | SAMSUNG09004 COMPUTER | LENOVO3200018-Feb-200437000 03-April-200457000 20-May-200409005 | LAPTOPDELLData for Customer Details tableCUSTOMERIDQUANTITY525IDCUSTOMERNAME CITY09001 | KALIFA09002 ABDUL AZIZ09003 ABDUL09004 | МОНАМED09005 AHAMEDNIZWACO001BARKA84005250525CO002SOHARC0003NIZWABARKACO001CO0043150

It is defined as a Structured Query Language, is a programming language designed to manage data…

1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to change the LOCATION of CUSTOMER as “BARKA" and who's quantity is LESS than 1000. 3. Write an SQL query to display all information from items table and display orders delivered in the month of June.

1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to change the LOCATION of CUSTOMER as “BARKA" and who's quantity is LESS than 1000. 3. Write an SQL query to display all information from items table and display orders delivered in the month of June.

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

For each band that currently has a female member: Return the name of the band and each artist's full name (as a single value). Order by band name and artist name. Attached is sql tables and their values
A customers table has the following columns: ID, NAME, AGE, ADDRESS and SALARY. Write an SQL code that will fetch the ID, NAME and SALARY fields from the CUSTOMERS table where the Salary is greater than 2000. Show result
Which restaurant id had the highest number of orders placed in June 2021? Write SQL code, The columns are Date (yyyy-mm-dd), CustomerId,OrderiD and restaurant ID. The table name is data
Write and SQL query using the MAX operator to show all data from the Order Items table in which the highest amount was paid for each item.
1. Write an SQL query to find all customers whose name (either last name or first name) contains “brown”. (Make sure the search is case insensitive.) 2. Write the SQL query to update all products’ discount per cents to 25% whose prices are more than $2000. Also, update the dateAdded field with the current date
Write SQL statements to the following queries. Retrieve customer FULL_NAME which full name (starts with uppercase letter N and end with lowercase letter i) or (starts with uppercase letter K and end with lowercase letter d) in ascending order of FULL_NAME.
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-Jun-2001 Male 98877445 22114454 A 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male B 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinai 24-Feb-2004 Male Negative 91122544 AB 66 YES 1005 Shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT NULLIF(phone, fax) FROM patients WHERE medical no = 1001; Answer:
P7
Based on the picture please help me write an SQL querey for each (don't answer the actual question just please write an SQL querey) Write an SQL Query to list the name(s) and address(es) of employees who work at the department named- 'Human Resources’? (Hint: Use Table Joining) Write an SQL Query to list the names of all projects run by the department – ‘IT Transformation’? (Hint: Use Table Joining) Write an SQL Query to list the department number and the count of projects in each of these departments and only display those values that has more than 3 count. Rename the count column as ‘Project Count’. (Hint1: Use GROUP BY and HAVING. You need not use table joining) (Hint2: It is OK to see an empty outcome as long as your query is correct) Write an SQL Query to count unique ‘Female’ employees who have been designated as ‘Staff’ and also have worked for more than 20 hours on a single project? Rename the count value as ‘Employee Count’ (Hint: Use Table Joining).
MICROSOFT SQL SERVER ONLY CURSOR T-SQL Obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT.
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME DOB GENDER BLOOD TYPE PCR TEST PHONE FAX WEIGHT SMOKER 1001 Said Alalawi 12-Jun-2001 Male 98877445 22114454 68 NO Negative 1002 Othman Mualla 20-Apr-2000 Male 78 YES Positive 1003 Sameera Bader 19-Oct-2005 Female 25541122 52 NO Positive 1004 Fahad Alhinal 24-Feb-2004 Male 91122544 AB 66 YES Negative 1005 Shamsa Alfahdi 15-Sep-2002 Female 35 NO Negative SELECT COALESCE (phone, fax, 9999) FROM patients WHERE blood_type='A'; Answer:
Write an SQL query using the IN operator to show all customers residingin the following zip codes: 91508, 91510, 33111