Only q2 Consider the following customer table and write SQL queries. (Queries should be hand written on paper) Customer Cuatio CustFrame Cusastme CustState CustZp Custial 1. List the customer number, the name (first and last), the city, and the balance of customers who reside in Denver with a balance greater than $ 150 or who reside in Seattle with a balance greater than $300. CustStreet 2. List the average balance of customers by city. Include only customers residing in Washington State (WA).

Only q2 Consider the following customer table and write SQL queries. (Queries should be hand written on paper) Customer Cuatio CustFrame Cusastme CustState CustZp Custial 1. List the customer number, the name (first and last), the city, and the balance of customers who reside in Denver with a balance greater than $ 150 or who reside in Seattle with a balance greater than $300. CustStreet 2. List the average balance of customers by city. Include only customers residing in Washington State (WA).

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

using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount
Write PL/SQL coomands for the following question5. Table student( name,age,inter_mark,entrance_rank,address,contact_no,ID,branch)Admission( college_name,mode( pay/free/star/NRI), date,ID)a) Write a query to display the students who are all admitted on starmode branchwiseb) Display the college under which maximum NRI student admittedc) Display the college which got minimum free students and atmost one NRI studentd) Display the student who got second maximum rank admission detailse) Display the students category wise admission detailsf) Write a plsql routine to check a perfect square number is the given number.
8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands
By using this table answer this question in SQL : Write a SQL query, which shows a list of all employees last name, their department names and their department city where that department is located from the employees table. If an employee does not belong to a department, then their department number and department name should show as “N/A” and their department city should show up as “No City info Found”. MAKE SURE you have all the employees displayed including the employees who do not have a department.
Please written by computer source I do not know which table to use here all the tables —— Pls use oracle Pl/sql command line —— The system must contain tables such as category(catNo ,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo), Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity) . create getItemTotalPrice function which to return quantity*paidPrice . --- procedure to add new Category which use validation method checkExistingCategory using exception to validate category name if its not exists before, then add this category and generate the category number automatically using database trigger.
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…
Using DML SQL, write the appropriate SQL query for each of the following:a) Insert A new customer with the following information:(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)b) Delete all the loans for customer with SSN: 2222c) Select all customer who got loans more than 250000 SAR, print the customers SSN, named) Print all the Accounts in Bank: ALBILAD and in branch no: 5
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.
Need help writing SQL statements for these, I'm having trouble with my returns. Explanation would help a lot.
Use the following tables to write the SQL queries: Table Name: Employees Write SQL Command to display employee first name , salary and new column called Degree. Evaluate the new column data based on the following EMPLOYEE_ID FIRST_NAME HIRE DATE JOB_ID SALARY DEPARTMENT_ID 100 Steven 02/13/2008 AD PRES 24000 90 101 Neena 05/20/2010 AD_VP 17000 90 102 Lex 09/11/2013 AD VP 17000 90 103 Alexander 09/01/2010 IT PROG 9000 60 104 Bruce 01/17/2012 IT PROG 6000 60 02/21/2018 conditions: 105 David IT PROG 4800 60 If salary is more than 20000 then Degree is PHD If salary is more than 10000 then Degree is 106 Vali 10/04/2018 IT PROG 4800 60 107 Diana 10/06/2019 IT PROG 4200 60 114 Den 08/05/2015 PU_MAN 11000 30 115 Alexander 01/14/2016 PU CLERK 3100 30 Table Name: Departments Table Name: Locations DEPARTMENT_ID DEPARTMENT_NAME LOCATION_ID LOCATION_ID POSTAL_CODE CITY COUNTRY_ID 10 Administration 1700 1400 26192 Southlake US 30 Purchasing 1700 1500 99236 South San Francisco US 50 Shipping 1500…
Question 14 List the three mistakes in the following SQL code: SELECT tblCustomer FIELD Customer#, CustomerFirstName, CustomerLastName CRITERIA Customer#=100;
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