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: 305 Weeks Ago, 1 Day 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 04 Jan 2018 My Price 10.00

SQL statement to list the INVOICE.InvoiceNumberfor

Write an SQL statement to list the INVOICE.InvoiceNumberfor 'Book' sales. Use a subquery. (Hint: The correct solution uses three tables in the query)

Write an SQL statement to list the FirstName, LastName and Phone of customers (list each name only once) who have attended the 'Kitchen on a Big D Budget' seminar.

 

InvoiceNumber InvoiceDate CustomerID PaymentType SubTotal Shipping Tax Total
35000 2013-10-15 3 VISA 22.94 5.95 1.31 30.2
35001 2013-10-25 4 MasterCard 47.89 5.95 2.73 56.57
35002 2013-12-20 7 VISA 24.95 5.95 1.42 32.32
35003 2014-03-25 4 MasterCard 64.85 5.95 3.7 74.5
35004 2014-03-27 6 MasterCard 94.79 5.95 5.4 106.14
35005 2014-03-27 7 MasterCard 94.8 5.95 5.4 106.15
35006 2014-03-31 9 VISA 47.89 5.95 2.73 56.57
35007 2014-04-03 11 MasterCard 109.78 5.95 6.26 121.99
35008 2014-04-08 5 MasterCard 47.89 5.95 2.73 56.57
35009 2014-04-08 1 VISA 47.89 5.95 2.73 56.57
35010 2014-04-23 3 VISA 24.95 5.95 1.42 32.32
35011 2014-05-07 9 VISA 22.94 5.95 1.31 30.2
35012 2014-05-21 8 MasterCard 54.89 5.95 3.13 63.97
35013 2014-06-05 3 VISA 47.89 5.95 2.73 56.57
35014 2014-06-05 11 MasterCard 45.88 5.95 2.62 54.45
35015 2014-06-05 12 MasterCard 94.79 5.95 5.4 106.14
35016 2014-06-05 3 VISA
InvoiceNumber LineNumber ProductNumber Quantity UnitPrice Total
35000 1 VK001 1 14.95 14.95
35000 2 VB001 1 7.99 7.99
35001 1 VK001 1 14.95 14.95
35001 2 VB001 1 7.99 7.99
35001 3 BK001 1 24.95 24.95
35002 1 VK004 1 24.95 24.95
35003 1 VK002 1 14.95 14.95
35003 2 BK002 1 24.95 24.95
35003 3 VK004 1 24.95 24.95
35004 1 VK002 1 14.95 14.95
35004 2 BK002 1 24.95 24.95
35004 3 VK003 1 19.95 19.95
35004 4 VB003 1 9.99 9.99
35004 5 VK004 1 24.95 24.95
35005 1 BK001 1 24.95 24.95
35005 2 BK002 1 24.95 24.95
35005 3 VK003 1 19.95 19.95
35005 4 VK004 1 24.95 24.95
35006 1 BK001 1 24.95 24.95
35006 2 VK001 1 14.95 14.95
35006 3 VB001 1 7.99 7.99
35007 1 VK003 2 19.95 39.9
35007 2 VB003 2 9.99 19.98
35007 3 VK004 2 24.95 49.9
35008 1 BK001 1 24.95 24.95
35008 2 VK001 1 14.95 14.95
35008 3 VB001 1 7.99 7.99
35009 1 BK001 1 24.95 24.95
35009 2 VK001 1 14.95 14.95
35009 3 VB001 1 7.99 7.99
35010 1 BK001 1 24.95 24.95
35011 1 VK002 1 14.95 14.95
35011 2 VB002 1 7.99 7.99
35012 1 VK003 1 19.95 19.95
35012 2 VB003 1 9.99 9.99
35012 3 VK004 1 24.95 24.95
35013 1 VK002 1 14.95 14.95
35013 2 VB002 1 7.99 7.99
35013 3 BK002 1 24.95 24.95
35014 1 VK002 2 14.95 29.9
35014 2 VB002 2 7.99 15.98
35015 1 VK002 1 14.95 14.95
35015 2 BK002 1 24.95 24.95
35015 3 VK003 1 19.95 19.95
35015 4 VB003 1 9.99 9.99
35015 5 VK004 1 24.95 24.95
35016 1 VK001 1 14.95 14.95
35016 2 VB001 1 7.99 7.99
35016 3 VK002 1 14.95 14.95
35016 4 VB002 1 7.99 7.99
45.88 5.95 2.62 54.45

 

Answers

SophiaPretty
(5)
Status NEW Posted 04 Jan 2018 12:01 PM My Price 10.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)