Question 3You are working with the Chinook database. You want to find the first and last names of customers who have a value in the country column of either 'Brazil' or 'Argentina'. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)
Question
Question 3You are working with the Chinook database. You want to find the first and last names of customers who have a value in the country column of either 'Brazil' or 'Argentina'. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)
Solution
The query you need to use to find the first and last names of customers from either Brazil or Argentina in the Chinook database would look like this:
SELECT FirstName, LastName
FROM Customers
WHERE Country IN ('Brazil', 'Argentina');
Here's what this query does, step by step:
-
SELECT FirstName, LastName: This part of the query selects the data you want to see. In this case, you want to see the first and last names of the customers. -
FROM Customers: This part of the query specifies the table you want to pull data from. In this case, you're pulling data from the Customers table. -
WHERE Country IN ('Brazil', 'Argentina'): This is the condition for selecting the data. It's saying "only give me the rows where the Country is either Brazil or Argentina". TheINkeyword is used to specify multiple possible values for a column.
Similar Questions
1.Question 1What is filtering in SQL?1 pointChanging a table to match a conditionRemoving unnecessary data from the databaseRemoving invalid recordsSelecting data that match a certain condition2.Question 2You are working with the Chinook database and want to return the firstname, lastname, and phone of all employees. Replace --??? with the missing information to complete the query. (If you want to undo your changes to the query, you can click the Reset button.)12--???FROM employees;RunResetWhat is Andrew Adams' phone number?1 point+1 (403) 467-3351+1 (780) 836-9987+1 (403) 262-3443+1 (780) 428-94823.Question 3A security analyst wants to filter the log_in_attempts table for records where the value in the country column is 'Canada'. What is a valid query for this?1 pointSELECT WHERE country = 'Canada'FROM log_in_attempts;SELECT *FROM log_in_attemptsWHERE country = 'Canada';SELECT *FROM log_in_attemptsWHERE country = Canada;WHERE country = 'Canada'SELECT *FROM log_in_attempts;4.Question 4Which pattern matches with any string that starts with the character 'A'?1 point'%A''A''A%''%A%'
Select all the different values from the Country column in the Customers table.
You have a database with a customers table. Here is a partial listing of the records:First_NameLast_NameMichelleSenseAlexisRodriguezFloraSatoYou also have a table of employees. Here is a partial listing of the records:First_NameLast_NameSamuelClementineAlexisRodriguezJabariReddyYou want to create a query that will not return “Alexis Rodriguez” as part of the results. You begin typing your query:SELECT First_Name, Last_Name FROM customers________SELECT First_Name, Last_Name FROM employeesWhat should you type in the blank space between the two queries? (Please type your answer all in upper case. Example: SELECT)
Select all the columns from the Customers table for customers whose country is not the UK.
Write queries for the following.Employee ( EID, Name, Age, Salary)Department ( DID, D_Name, EID,Country)(1) Create a view Emp_India which contains the name, age and salary of Indianemployees.(2) Display the name of employee in descending order whose Country starts with ‘I’
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.