Question: Can you please hand write the correct answers. Write an SQL query to do the following tasks using the Exercise 4 Practice Data. You must

Can you please hand write the correct answers.

Write an SQL query to do the following tasks using the Exercise 4 Practice Data. You must work ONLY with the information given in the task. 1. List the names of the customers with their telephone numbers. 2. List the names of the products produced by "DivEight". Phone Division Contract Phone Ne CID 1001 1002 CID Type DID Name Address ConCode Markup 123 Apple St 101 Maple St 8881279800 Cell I US Rd D8 DivEight8 Idaho Rd 3 Maine St 1002 Wholesaler 1003 8725389377 Cell OrderLineltem Production CID ConCode CID ype Name Price PID PID OID D ID 1002 Hardware 1004 Hardware OldContracts ConCode Markup CID 10/1/2017 10/1/2017 10/1/2017 102/2017

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Phone Division Contract Phone Ne CID 1001 1002 CID DID Name Address ConCede Markup 123 Apple St 101 Maple St 12 Dupe St. 12 Tiger Rd. 88 Chico St. 8881279800 Cell I US Rd DS DivEight8 Idaho Rd 3...

A Case Study : Vine Estate Agency Ltd (VEA) is a licensed estate agent, providing a variety of services such as property management, sales, auction, etc. The following is a brief description of the...

Database I Lab 3 Due Date: On or Before Thursday February 25, 2021 Objective(s) Target CLO(s) Reference To practice the INSERT , UPDATE , DELETE , and SELECT commands of SQL DML. 6 Chapter 6 Name ID...

Database I Lab 3 Due Date: On or Before Thursday February 25, 2021 Objective(s) Target CLO(s) Reference To practice the INSERT , UPDATE , DELETE , and SELECT commands of SQL DML. 6 Chapter 6...

Chapter 9 Exercises: #9.47, 9.61, 9.73 The questions are below please this is data base management system SQL please help 9.47 Define rollback and rollforward. 9.61 Explain what problems can occur in...

Answer the following True/False, Multiple Choice, Fill in blank as QUICKLY AS POSSIBLE*. Please let them be correct answers. No explanation needed. 1 When conducting a one-sample t test, if a sample...

I am in need of person skilled in Python and SQLite to help me with this problem. I have posted this several times on Chegg, but nobody has helped, and they all have not read my problem thoroughly...

Implement the following tasks using ORACLE Application Express (APEX). Download the file H2HSchema.sql from the LMS site and run it on APEX. This file contains all the CREATE and INSERT statements...

CPSC 1150: Lab 9 [35 marks] Objectives: 1. Write several methods that use and manipulate arrays 2. To become familiar with writing to and from files 3. To practice method decomposition, arrays, and...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Assume that you receive an income tax refund of $1,400. Given your current situation, what is the best thing that you could do with this refund?

Based on the description of the Reliable Pharmaceutical Service system in Chapters 5 and 6 and the DFDs you developed for Chapter 6, develop a system flowchart and structure charts for the system....

AHJ Haulers is a professional moving company. AHJs owner, Ashley, instructed the accounting team to estimate the companys scope 1 greenhouse gas emissions. As a result, AHJ assembled the following...

Shadee Corporation expects to sell 560 sun shades in May and 370 in June. Each shade sells for $158. Shadee's beginning and ending finished goods inventories for May are 75 and 50 shades,...

8. One way to diagnose transfer of training problems or to ensure that transfer of training occurs is to complete the matrix shown below. This matrix considers the responsibilities of the manager,...

5. This assignment relates to Application Assignment 2 in Chapter 4. You now receive the following e-mail from the vice president of operations. Prepare an answer. Thanks for your recommendations...

2. Identify and choose outcomes to evaluate a training program.