1. I need to see all of the records on invoices with totals of either less than 5 or more than 10 within customer ids of

Post by **answerhappygod** » Thu Jul 14, 2022 2:28 pm

: 1 I Need To See All Of The Records On Invoices With Totals Of Either Less Than 5 Or More Than 10 Within Customer Ids Of 1 (33.36 KiB) Viewed 31 times

1. TRUE and !(TRUE or FALSE) and !TRUE or FALSE
2. TRUE or TRUE and FALSE or !TRUE and !(TRUE or TRUE)
3. TRUE or !(TRUE and FALSE and !(TRUE and FALSE))
4. FALSE or !TRUE and TRUE
5. TRUE or !FALSE and TRUE or !(TRUE or TRUE and !FALSE)
6. !(TRUE and !((!(FALSE and TRUE) and TRUE) or FALSE) or FALSE)
7. TRUE and FALSE or !TRUE and !(TRUE and FALSE) and !(TRUE or TRUE)
8. TRUE or !FALSE and !(TRUE or FALSE) and FALSE
9. !TRUE or FALSE and FALSE and (!(TRUE and FALSE) or TRUE)
10. TRUE or FALSE and TRUE or !(TRUE and FALSE or TRUE)
1. I need to see all of the records on invoices with totals of either less than 5 or more than 10 within customer ids of 40−100. I only want to see the billing city, total, and billing country in that specific order sorted based on invoice date on descending order. 2. Return the list of customers with Gmail emails who are in countries that have ' A ' in the name of the country. You can also get rid of the ones that have null for company. Sort it based on the first name of the customer. I like you to return first name, last name, postal code and fax number in that order. 3. Give me the list of artists with 5 letters names 4. Give me list of artists with names starting with B and ending with y or the names that are starting with Y and ending with b. 5. Write a query that will get a track name and return the Genre of that track 6. Write a query that will get a track name and return the Media Type of that track 7. Write a query that returns the sum of 1 and 2 8. Write a query that returns the sum of average of total in invoice, largest and smallest values of total 9. I need to see the media type of an album e.g. 'Out Of Exile'. Your query should take the name of the album and return the media type 10. Write a query that takes first name and last name of an Employee and returns a list of people who should report to that employee e.g. Andrew Adams. Nancy Edwards and MichaelMitchell should report to him.