Practice Logical Operator with Chinook

Retrieve the titles of albums from the Album table that have a title length greater than 30 characters and less than 40 characters.

Select all details of customers from the Customer table who do not have a company name and do not provide a fax number.

Retrieve all details of customers from the Customer table who are located in either Brazil or Portugal and do not have a fax number listed.

SELECT * FROM Track WHERE (MediaType = 'Audio' OR MediaType = 'Video') AND NOT (Genre = 'Pop');

Select the CustomerId of customers from the Customer table whose last names are 6 characters or shorter and who are not located in the USA.

Retrieve all details from the InvoiceLine table where either the InvoiceId or the TrackId is even, but not both.

Select the CustomerId and BillingCity from the Invoice table for customers whose IDs are even and less than 30, and whose total invoice amount exceeds $5.00.

Retrieve all details from the Invoice table where any of the billing address fields (BillingCity, BillingState, BillingCountry, BillingPostalCode) are NULL, and where the total amount of the invoice is less than $1.00.

Find all tracks from Track table that are longer than 6 minutes (360000 milliseconds) and have a file size larger than 7 MB (7000000 bytes), but excluding any tracks from GenreId 1 and where the AlbumId is not null.

Identify tracks that might be shorter than 2 minutes or have no composer listed, but still priced at the standard 0.99.

Write a query to retrieve the following information:

• Select the columns: EmployeeId, FirstName, LastName, and Email from Employee table.
• Apply the following filtering criteria:
  • Include employees who hold the title 'Manager' and were hired before January 1, 2003.
  • OR include employees who do not hold the title 'Manager', were hired on or after January 1, 2003, and were born before January 1, 1970.
• Ensure that:
  • The employee's BirthDate is after January 1, 1960.
  • The employee's City is not 'Calgary'.
  • The employee's Email does not end with @gmail.com.
• Order the results by BirthDate in ascending order.