Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a query that gets all the Invoices ID from all the invoices which total is greater than the total invoice with ID =12 enployees
Create a query that gets all the Invoices" ID from all the invoices which total is greater than the total invoice with ID =12 enployees Employeeld integer LastName nvarchar(20) FirstName nvarchar(20) Title nvarchar(30) Reports To integer BirthDate datetime 11 HireDate datetime Address nvarchar(70) nvarchar(40) State nvarchar(40 IT Country nvarchar(40) Reports Topptakode nvarchar(10) Phone nvarchar(24 nvarchar(20 Email nvarchar(60) Supporteple Employeeld artists Artistid integer Name nvarchar(120) Artist Artistid customers Customerld integer First Name nvarchar(40) Last Name nchar(20) 1 Company nvarchar(80) Address nvarchar(70) nvarchar(40) I State nvarchar(40) 1 Country nvarchar(40) I Postal Code nvarchar(10) IPhone nvarchar(24 VFF nvarchar(24) Email machar 1 SupportRepldintage I Cly media_types MediaTypeld integer Name nvarchar(1200 albuns Albumid Integer Title nvarchar(160) Artistid integer genres Geweld integer Name nvarchar(120) MediaTypeld MediaTypeld Genreld Genreld Albumid Albumid Customer Customerld tracks invoices Invoiceld integer Customer la integer InvoiceDate datetime BalingAddress nvarchar(70) Billing City nvarchar(40) Baling State nvarchar40) Billing Country nvarchar(40) BalingPostalCode nvarchar(10) Total numeric(10,2) Trackle integer Name nvarchar(200 Albumid integer MediaTypeld integer Genreld integer IT Composer nvarchar(220) Malliseconds intege Bytes integer UnitPrice numeric (102) playlists Playlistid integer If Name nvarchar(120) Playlist Playlistid Trackid Trackid voeld invoice Frachterario invoice_itens Invoicelineld integer Invoicela integer Trackld integer UnitPrice numeric(10.23 Quantity integer playlist_track Playlistid integer Trackld integer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started