QI/ By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_on_hand, vend_code) Vender(vend code, vend_fname, vend_areacode, vend_salary, vend country) 1- find the venders names who have salary less greater than the average salary of venders who sell in area code 7655. 2- find the code, name and vender code of product that has price between 1 5000S and 30000$ and the product that has price between 300S and 5800S. 3- Find the name of italian venders who has salary less than the average salary of venders. 4- Find the names and area code of iraqi venders. 5- Decrease the price of all product by 20%

QI/ By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_on_hand, vend_code) Vender(vend code, vend_fname, vend_areacode, vend_salary, vend country) 1- find the venders names who have salary less greater than the average salary of venders who sell in area code 7655. 2- find the code, name and vender code of product that has price between 1 5000S and 30000$ and the product that has price between 300S and 5800S. 3- Find the name of italian venders who has salary less than the average salary of venders. 4- Find the names and area code of iraqi venders. 5- Decrease the price of all product by 20%

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

By using this table answer this question in SQL: Show the department id, department name and the number of employees working in any department which has less than 4 employees
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
Q5: From the Customer table given below write SQL queries for the following question?  Write a query to display the record of the last name and city with unique state? Write a query to display the record of the distinct cities of the customers? Write a query to display the records of customers' address whose names contain letter “a”?
please answer all parts within 30 monutes.
Quèstion 12 Write SQL queries for the following: i. Insert all rows from Product table into Parts table by using subquery. ii. Find the average of the sales Amount column in Sales table where supplier ID is S212. i. select all the details of the suppliers from the Supplier table where Supplier.address starts with "Toy. TTT Arial 3 (12pt)
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.
QI/ By Using the following schema, answer the following SQL queries and commands: Product(P_code,P_name, P_price, P_on_hand,vend_code) Vender(vend code, vend_fname, vend_areacode, vend salary, vend_country) 1- find the venders names who have salary less greater than the average salary of venders who sell in area code 7655. 2- find the code, name and vender code of product that has price between 15000$ and 30000$ and the product that has price between 300$ and 5800$. 3- Find the name of italian venders who has salary less than the average salary of venders. 4- Find the names and area code of iraqi venders. 5- Decrease the price of all product by 20%
Write in SQL
1. Find out each manager's work address. Note that a manager's work address is the same as the address of the department which s/he manages. • Address Format: Street_AddressPostal_Code CityCountry_Name • Write query in oracle sql.
QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name, P_price, P_quantity, vend_name) Vender(vend code, vend fname, vend_areacode, vend salary, vend_nationality) find the names of products that owned by vender "smith" and not owend by vender "dan." 1- find the name, price and quantity of product that has code 34657 and owned by spanish venders. 2- 3- Find the name of iraqi venders who has salary less than the average salary of venders. Find the prodect name that their quantity greater than 17 and oreder them by vender name. 4- 5-add new column to the product table called p_company.
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.