4. List all customers (last name, first name and zip code) whose zip code is missing (unknown). 5. List the name and phone number of the customer with area code of '678'. 6. We'd like to markdown by 10% the price of the product whose price is greater than or equal to 300. List the ID, category, price, and mark-downed price. Rename the mark- downed price as 'SalePrice'.

4. List all customers (last name, first name and zip code) whose zip code is missing (unknown). 5. List the name and phone number of the customer with area code of '678'. 6. We'd like to markdown by 10% the price of the product whose price is greater than or equal to 300. List the ID, category, price, and mark-downed price. Rename the mark- downed price as 'SalePrice'.

MIS

9th Edition

ISBN:9781337681919

Author:BIDGOLI

Publisher:BIDGOLI

Chapter3: Database Systems, Data Warehouses, And Data Marts

Section: Chapter Questions

Problem 6P

See similar textbooks

Similar questions

51. The given SQL statement is intended to either (1) list the customer numbers, customers names, and headquarter cities of customers headquartered in Los Angeles or (2) satisfy the two conditions of having a customer number higher than 1000 and being headquartered in Denver. SELECT CUSTNUM, CUSTNAME, HQCITY FROM CUSTOMER WHERE HQCITY= 'Los Angeles" Which set of lines should be added to the end of the statement to make the statement work as intended? A: (CUSTNUM>1000 AND HQCITY-'Denver'); B: AND (CUSTNUM>1000 AND HQCITY='Denver*); C:OR CUSTNUM>1000 OR HQCITY='Denver": D:OR (CUSTNUM> 1000 AND HQCITY='Denver*);
List the top-3 states that have the most number of employees. Show the state and the number of employees. Give the new column an alias and sort the results according to the highest number of employees.
4.9 LAB - Select employees and managers with inner join The Employee table has the following columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string ManagerID - integer Write a SELECT statement to show a list of all employees' first names and their managers' first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like "Employee" and "Manager". Hint: Join the Employee table to itself using INNER JOIN.
Which of the followings describe the relationship between “super key” and “candidate key”?(a) A super key is also a candidate key.(b) A Super key K is a candidate key, if K is minimal(c) A candidate key K is a super key, if K is minimal(d) A candidate key is also a super key
Answer number 10,12 and 13 Write the SQL statement to generate the report the following 1. Generate a report for all employees in Ascending order 2. Generate a report for all employees in Descending order 3. Generate a report for all employees in Ascending order with their assigned offices 4. Generate a report for all employees in Descending order with their assigned offices 5. Generate a report on customers 6. Generate a report on all customers and assigned sales reps 7. List all payments within a specified time frame of your choice 8. List all the sum total of all products orders. 9. Fetch the highest paying customer. 10. Fetch the highest paying employee 11. Fetch the highest paying product 12. Fetch all orders with complaints 13. Create a report on the total profits of the following offices a. NYC b. London c. Paris d. Tokyo 14. Fetch the lowest paying customer. 15. Fetch the lowest paying employee 16. Fetch the lowest paying product
Please I want the EER or E-R Digram for this question: A patient is identified by patient id, and admission date. • A patient must be either an Emergency patient or a resident patient. • We must record the checkback date for Emergency patient. • Only resident patient is assigned to one room. Room has a unique number, degree, and floor number. • For each room there are a number of beds each of which has a bed number, specification. If a room is deleted, you need not keep track of its beds any longer. • Both emergency patient and resident are cared for by a responsible Doctor. Doctor is identified by Doctor number. For each Doctor, the name, several specialty, and years of experience must be recorded. • Doctors prescribe medicine for patients. Medicine is identified by trade name that has scientific name and formula. The medicine depends on another medicine to be taking before. • A doctor could prescribe one or more drugs for several patients, and a patient could obtain prescriptions…
Consider Food item table attributes are food item key, food item and quantity. Time table attributes are year, quarter, month and day. Product table attributes are model name, model year, and category. Sales fact table attributes are sales dollars and sales quantity. Q.1 Design an appropriate schema for the above information Q.2 Create "dim" for the above information using the SQL statement. Q.3 Add attribute clause in the dimension clause. Q.4 Add “rollup” hierarchy in “dim” with appropriate levels and alter to add attribute.
1) List all products with their highest unit price, i.e. not discounted.2) List the average unit price for each product category andthe average unit price without discounts
Write SQL statements to answer the following questions using Assignment 3’s schema (tables below). You can add more data to the tables if you want, just follow the PK and FK rules. Accounts are not Loans and Loans are not Accounts. NOTE I already have Answers for part 1 BELOW PART 1 IS FOR ONLY REFRENCE TO ANSWER QUESTIONS 6-11 6- Find Customer ID, Customer name and the number of loans for each Customer. 7- Find Loan number and Customer Id of the loan with the lowest amount. 8- Create a view called Gary_Branch_V that contains Branch Id, Branch name, and number of loans for each Branch that is in the city of Gary. 9- For each Customer in Hopkins, find the balance in their account(s). 10- Find how many different accounts each customer has at each Branch. The output should be a list of Customer ID and for each Customer ID, the number of accounts for this customer by Branch ID. 11- Find the branch with the highest or largest Average loan amount. List the Branch ID, Branch…
can you help me iwth these two queries in mySQL. Write a SQL statement to create a table job_history including columns employee_id, start_date, end_date, job_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key column job_id contain only those values which are exists in the jobs table. Write a SQL statement to create a table employees including columns employee_id, first_name, last_name, email, phone_number hire_date, job_id, salary, commission, manager_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key columns combined by department_id and manager_id columns contain only those unique combination values, which combinations are exists in the departments table.
Consider the following two tables: Draw three tables that can result by executing each of the following SQL statements. . 1. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c INNER JOIN Orders AS o ON c. customerID = o. customerID; 2. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c LEFT OUTER JOIN Orders AS o ON c. customerID = o. customerID; 3. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c RIGHT OUTER JOIN Orders AS o ON c. customerID = o. customerID;
I need original answer not plagiarized. Otherwise I'll give you multiple dislikes.

SEE MORE QUESTIONS

Recommended textbooks for you

MIS

Computer Science

ISBN:

9781337681919

Author:

BIDGOLI

Publisher:

Cengage

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

MIS

Computer Science

ISBN:

9781337681919

Author:

BIDGOLI

Publisher:

Cengage

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS