Consider the below tables. Customer CustomerNo (PK) Order Order No CustomerName Ali AlMansoori 12 Sarah Sulaiman 13 Maha Al Ali 11 OrderDate 110 10/01/2018 114 11/01/2018 116 14/01/2018 118 12/01/2018 120 14/01/2018 122 17/01/2018 CustomerAddress Block A, No. 6, Khalifa B Aljazeera Tower, Aprt 180, Corniche Rd Etihad Tower, Aprt 2022, Hamdan ST Order Amount 17000 8000 21000 22000 42500 50100 CustomerNo (FK) 11 12 12 13 11 13 Write a query to display the order number, order amount for all orders made by customer Sarah with amount greater than 8000, displaying orders made later first.

Consider the below tables. Customer CustomerNo (PK) Order Order No CustomerName Ali AlMansoori 12 Sarah Sulaiman 13 Maha Al Ali 11 OrderDate 110 10/01/2018 114 11/01/2018 116 14/01/2018 118 12/01/2018 120 14/01/2018 122 17/01/2018 CustomerAddress Block A, No. 6, Khalifa B Aljazeera Tower, Aprt 180, Corniche Rd Etihad Tower, Aprt 2022, Hamdan ST Order Amount 17000 8000 21000 22000 42500 50100 CustomerNo (FK) 11 12 12 13 11 13 Write a query to display the order number, order amount for all orders made by customer Sarah with amount greater than 8000, displaying orders made later first.

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

write the following queries (n) Identify flats with at least three rooms and with a monthly rent no higher than £500 in Aberdeen. (0) List the details of leases due to expire next month at a given branch. (p) List the total number of leases with rental periods that are less than one year at branches in London. (q) List the total possible daily rental for property at each branch, ordered by branch number. System Description: Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manages the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly…
According to the given table, who is the secretary in the accounting department with experience in the personnel department?
Define Normalization & Normalize the following table to 3rd NF
Using SQL find the number of employees from the table:
according to tables below, Create 5 views that are reasonable
Insert the following records into the tables CLIENT and CLIENT_DETAILS CLIENT Client_no Client_Name Address Order Date C100 DELL AMERICA 05-05-2018 C101 SANDISK KINGDOM 10-10-1998 C102 SAMSUNG KOREA 12-08-2010 C103 LENOVO JAPAN 10-07-1998 CLIENT_DETAILS Client_no Order_No Product Cost Quantity Status C100 R001 JIOCLASS 100.40 3000 PROGRESS C101 R002 SMARTWATCH 300.50 4000 DELIVERED C102 RO01 SPYCAMERA 600.10 2000 PROGRESS C103 R003 IROBOT 4000 DELIVERED C104 R002 RADAR 500.00 400 PROGRESS
Using the SELECT statement, query the invoice table to find the average total cost for all orders placed between 2011-01-01 and 2012-01-01. 0 5.7063106796116505 5.8095238095238095 5.7357723577235772
Make the following tables database:
Given the ORDER, ORDER_DETAIL, CUSTOMER, and PRODUCT tables. CUSTOMER CUSTOMER_ID CUSTOMER_NAME 1565 Emre 1789 Akif 1265 Eyup 4537 Fatih 6542 Murat CITY CITY_ID CITY_NAME 1 Gaziantep 2 Balıkesir 3 Edirne 4 Van 5 Rize 6 Kayseri ORDER ORDER_ID ORDER DATE 1 05.08.2012 2 11.04.2015 3 12.06.2013 4 02.05.2015 5 02.09.2014 ADDRESS CITY_ID CITY_NAME Gatem 2 Rasaf yolu 1 Damlacık 6 köyü Seyrantepe 1 Sarıgüllük PRODUCT PRODUCT_ID PRODUCT_NAME PRICE (TL) 1 Bilgisayar 3250 2 Telefon 1800 3 Monitör 650 4 Klavye 45 5 1200 Televizyon Masa 6 60 CUSTOMER_ID 1565 1265 4537 6542 1565 ORDER_DETAIL ORDER_ID PRODUCT_ID 1 1 1 3 1 4 2 4 3 4 3 5 4 1 4 3 4 5 4 6 5 1 5 3
Q Normalize the following table up to 3 NF Ono Odate CustCN CustName City Phone PCode Pname CatId CatName Qty UPrice 1/12/2017 6893692 Amani Ruwi Marker Stationary Hardware Stationary Sports Stationary Stationary Sports 196 95251456 M1 150 1.2 R1 Printer 10 35 Pencil Football P3 173 1 190 1/11/2019 6893692 Amani Ruwi 95251456 P1 1 4 Pencil Marker Football P3 2 173 1 200 2/12/2020 1232345 Ahmed Salalah 898989980 M1 200 1.2 P1 1 5 4
Create the order table.
Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com | 2010-06-18 Irfan@abc.com Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.