Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write SQL to List the ID & name of employees and their department code that have placed an order with a line having a total

Write SQL to List the ID & name of employees and their department code that have placed an order with a line having a total cost more than $30.00. Also include the PO number and total cost. 

Hint the headings will look like this:

Phone number

Employee Id 

Total Cost 

Last name

First name 

Department code

Step by Step Solution

3.45 Rating (165 Votes )

There are 3 Steps involved in it

Step: 1

SELECT Phonenumber EmployeeId TotalCost Lastname Firstname Departmentcode ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Andersons Business Law and the Legal Environment

Authors: David p. twomey, Marianne moody Jennings

21st Edition

1111400547, 324786662, 978-1111400545, 978-0324786668

More Books

Students also viewed these Databases questions