Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi I need help with mysql You will need to create a new database and then run the NorthwindTablesAndData.sql Link to sql file on google

Hi I need help with mysql

You will need to create a new database and then run the NorthwindTablesAndData.sql

Link to sql file on google drive: https://drive.google.com/file/d/1nBXFuujXudCjzyvQ282NWB3qZhXplvmr/view?usp=drivesdk

image text in transcribed

The boss wants a list of prospects. A prospect is a customer that hasn't placed any orders yet. The boss wants the list with the company name, a contact person for the company and a phone number. Sort the list by the company's name. Here is the expected result. The boss, being a self-proclaimed SQL expert says the solution must use the EXISTS operator and a subquery CompanyName FISSA Fabrica Inter. Salchichas S.A Diego Rel (S1) 555 94 44 Paris spcialts ContactName Phone Marie Bertrand (1)42.34 22.66

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions