Create a database store. Create the table using design view. Item ItemID ItemName Section Price Sold CustomerNo IT101 Tshirt Garments 3 25 C1 IT102 Handbag Accessories 7 12 C2 IT103 Socks Garments 1 20 C1 IT104 Bracelet Accessories 5 C3 IT105 Blanket Décor 12 9 C2 IT106 Pillow Décor 10 32 C4 Create the table using SQL Create statement. Customer CustomerNo Location PurDate Amount C1 Nizwa 2/25/2021 30 C2 Muscat 2/24/2021 45 C3 Muscat 2/22/2021 55 С4 Nizwa 2/22/2021 60 Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with 'et' and are décor. 7. Display customer number and location of customer with amount not less than 50.

Create a database store. Create the table using design view. Item ItemID ItemName Section Price Sold CustomerNo IT101 Tshirt Garments 3 25 C1 IT102 Handbag Accessories 7 12 C2 IT103 Socks Garments 1 20 C1 IT104 Bracelet Accessories 5 C3 IT105 Blanket Décor 12 9 C2 IT106 Pillow Décor 10 32 C4 Create the table using SQL Create statement. Customer CustomerNo Location PurDate Amount C1 Nizwa 2/25/2021 30 C2 Muscat 2/24/2021 45 C3 Muscat 2/22/2021 55 С4 Nizwa 2/22/2021 60 Solve the following queries: 1. Display all details of the item table. 2. Display item name, section and price of all garments. 3. Display the number of customers from Muscat and their total amount. 4. Display the average of all garment items sold. 5. Display the maximum and minimum amount of the customer. 6. Display all items ending with 'et' and are décor. 7. Display customer number and location of customer with amount not less than 50.

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

Table Name Column Names REGIONS REGION ID, REGION NAME COUNTRIES COUNTRY_ID, COUNTRY_ NAME, REGION_ID LOCATIONS LOCATION ID, STREET ADDRESS, POSTAL CODE, CITY, STATE PROVINCE, COUNTRY ID DEPARTMENTS DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID, LOCATION ID EMPLOYEES ΕMPLOYEE D, FIRST NΑΜΕ, LAST NAMΕ, EΜAL , PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID JOB HISTORY EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARΤΜΕNT ID JOBS JOB ID, JOB TITLE, MIN SALARY, MAX SALARY
ORACLE SQL KIM TAY PET SUPPLIES Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW.
The screenshot of the Query and the results below is from the question of each number, and saved with the file name: UAS_NIM.docx or UAS_NIM.pdf Create database : - Show the name of the supplier who sells shoes at prices below the average shoe price- Show the name of the customer who bought shoes with odd sizes- Show Customer Name and Average Payment Amount for Customers who make 5transaction more than 1 Jenis_Sepatu: INSERT INTO Jenis_Sepatu values('S-01', 'Sepatu Lari');INSERT INTO Jenis_Sepatu values('S-02', 'Sepatu Basket');INSERT INTO Jenis_Sepatu values('S-03', 'Sepatu Soccer'); Supplier: INSERT INTO SUPPLIER Values('MA', 'PT. MitraAdi', 'Jl. Monginsidi 87');INSERT INTO SUPPLIER Values('SO', 'PT. Shakti Omega', 'Jl. Sudirman 23');INSERT INTO SUPPLIER Values('SS', 'PT. Sport Station', 'Jl. GunungKelud 8'); Merek: INSERT INTO Merek values('AS', 'Adidas','MA');INSERT INTO Merek values('DA', 'Diadora','SS');INSERT INTO Merek values('PA', 'Puma','SO');INSERT INTO Merek…
Question 2 and 3
Write the sql query to create given table.
Write all the sql code (including create, insert and select), screenshot the output alongside the codes please.
Write an SQL query to extract the answer directly.
Write the SQL9. Create an index called CUSTOMERIND on the CUSTID column in the CUSTOMER table
Please there is no time Sql
SQL SQL Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners. here is what i have so far but says query completed but nothing shows SELECT O.FIRST_NAME, O.LAST_NAME,P.ADDRESS FROM OWNER AS O,PROPERTY AS P two tables im grabbing the information from are attached owner table and property expected outcome FIRST_NAME LAST_NAME ADDRESS Ernest Burke 30 West Thomas Rd. Ceyda Aksoy 782 Queen Ln. Nicole Bianchi 9800 Sunbeam Ave. Jakub Kowalczyk 105 North Illinois Rd. Haydon Sims 887 Vine Rd. Elle-May Moore 8 Laurel Dr. Meerab Cole 447 Goldfield St. Jakub Kowalczyk 594 Leatherwood Dr. Makesh Patel 504 Windsor Ave. Janine Lopez 891 Alton Dr. Ammarah Jones 9531 Sherwood Rd. Seth Redman 2 Bow Ridge Ave. Haydon Sims 916 Kent Drive
4. Write a SQL statement to create a view named 'Employees_Purchase which will contain First Name, Last name and Salary of employees who are working in the Purchasing department.
Write an SQL query to extract the answer directly.