Reference no: EM133702736

Assignment1: SQL Queries Prerequisites: • Install SQLite and download the Chinook sample database Objective: • Understand how to build SQL statements to access data. Problem 1: Querying a Single Table 1a: Write a Query that returns the following data from the Customers table: a. FirstName and Last name concatenated into a single column, b. The Company Name c. Their city d. Their state Order the resulting data by city. 1b: Modify your query to only return customers from Canada or the United States 1c: Modify your query to only return customers in Canada or the United States whose last name starts with the letter M. Problem 2: Joining tables 2a: Write a query white returns the following information from the Artist, Albums and Tracks tables: a. Artist Name b. Album Title c. Track Names Order the results by Artists 2b: Modify the previous query so it only returns tracks that have the word "dancing" somewhere in the track name. 2c: You have been asked to create a org chart for the company. Create a query that returns two columns one with the employee's first and last name and the second with their managers first and last name. Example: Employee