QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name., P_price, P_quantity,vend_fname) Vender(vend_code, vend_fname, vend_areacode, vend_age, vend_nationality) 1- find the venders names who sell phones and microwaves and order them by the the product names 2- find the code, name and vender name of product that has price greater than 1800S and less than 2500S and their quantity less than 5. 3- Find the vender information who had 5 microwaves that has price less than the average price of ovens. 4- Find the names and area code of iraqi venders and younger than 33. 5- Delete all the air fans product that has price under 2500 .

QI/ Using the following schema, answer the following SQL queries: Product(P_code,P_name., P_price, P_quantity,vend_fname) Vender(vend_code, vend_fname, vend_areacode, vend_age, vend_nationality) 1- find the venders names who sell phones and microwaves and order them by the the product names 2- find the code, name and vender name of product that has price greater than 1800S and less than 2500S and their quantity less than 5. 3- Find the vender information who had 5 microwaves that has price less than the average price of ovens. 4- Find the names and area code of iraqi venders and younger than 33. 5- Delete all the air fans product that has price under 2500 .

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

How do I do this question in SQL command? Use the Oracle database employees table and CASE expression to decode the departmentid. Display the department id, last name, salary, and a column called “New Salary” whose value is based on the following conditions: If the department id is 10 then 1.25 * salary If the department id is 90 then 1.5 * salaryIf the department id is 130 then 1.75 * salary Otherwise, display the old salary.
1.What is the result when the following SQL query is executed on a table named products? Choose the most correct answer. SELECT AVG(Products)FROM Products; Group of answer choices The query results in an error because the is no AVG function None of the above The query results in an error be cause a column is not specified The query returns the average of the Products table 2. If the primary key in the Employee table is located in the "ID" column what is the maximum number of results the following SQL SELECT query will return? SELECT *FROM EmployeeWHERE ID = 15; Group of answer choices 2 1 3 Do not have enough information to determine the answer 0
Assume the following tables: Student (studid, email, name) Club (clubid, telephone, name, #president) MemberOf(#clubid, #studid ) Activities(actid, actdt, place) Organize (#actid , #clubid , fee), Then answer the following questions by using SQL. 1- Create a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated. 2- Create a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date. 3- Create a stored Procedure called 'CheckavailabilityProc' to call the function 'Checkavailability' and display the appropriate message according to the value returned by the function (If function returns true, the procedure will display 'Salalah Hall is free on date ######' otherwise'Salalah Hall is busy on date ###### ').
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60;Q1: Size of DogsThe Fédération Cynologique Internationale classifies a standard poodle as over 45 cm and up to 60 cm.The sizes table…
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.
12. Display the name, job, and salary for all employees whose job is Clerk or Analyst and their salary is not equal to $1000, $3000. or $5000. ΕΝΑΜΕ JOB SAL JAMES CLERK 950 SMITH CLERK 800 ADAMS CLERK 1100 MILLER CLERK 1300 13. Modify p2q6.sql to display the name, salary, and commission for all employees whose commission amount is greater than their salary increased by 10%. Rerun your query. Resave your query as p2q3.sql. Employee Monthly Salary COMM MARTIN 1250 1400
1. Write an SQL query to list the name of all Departments that have 2 more more words in the Department name and whose employees have the designation of a ‘staff’ and are from Houston. (write subqueries) 2. Write an SQL query to display the Project Name of all projects where employees have worked for 5 hours or less or 25 hours or more and the Project Names start with a “T” or a “C”. (write subqueries)
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.
1.Question Workspace Write an SQL query that displays the therapies and their unit of time for the therapies that include the word bath, hot, or electrical. 2.Question Workspace Write an SQL query to display every therapist's first name and last name as their full name, but only for those instructors not living in zip code 72511.
SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345