SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 18 Nov 2017 My Price 7.00

customers who haven’t bought any works of art.

Hi there,

 

I have another question to check with you. Kindly assist me. Thank you.

 

Kindly Provide SQL AND result tables for the following queries.

 

The tables are:

ARTIST

CUSTOMER

WORK

TRANS

CUSTOMER_ARTIST_INT

 

g. List the full name of any customers who haven’t bought any works of art.

 

h. Which artist (give his/her full name) has the most customers interested in him or her, and

how many customers are interested in them?

 

i. List the total dollar amount of sales each artist (give his/her full name) has made on their

works, in descending order of total.

 

j. List the name of any customers who have an interest in all the artists from the United States.

Your query should not need to include names of individual artists.

Answers

SophiaPretty
(5)
Status NEW Posted 18 Nov 2017 01:11 PM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)