Create a QUERY: 

• Choose a table that has an ID, name, and any other column of your selection.
• Write a QUERY returning id, name, and column of at least two IDs using the IN Operator.
• Explain what allowed you to return that specific ID.
• Include screenshot of code (no extra whitespace)
• Include screenshot of code result (no extra whitespace)

2. Create a QUERY: 

• Use the same table at Problem 1:
• Write a QUERY returning id, name, and column using the LIKE Operator.
• Explain what allowed you to return that specific ID.
• Include screenshot of code (no extra whitespace)
• Include screenshot of code result (no extra whitespace)

 

3. Create a QUERY: 

• Use the same table at Problem 1:
• Write a QUERY returning id, name, and column using BETWEEN AND Operator.
• Explain what allowed you to return that specific ID.
• Include screenshot of code (no extra whitespace)
• Include screenshot of code result (no extra whitespace)

 

4. Create a QUERY: 

• Choose any table, and any columns where you can select a range of values in the WHERE Clause.
• Write two queries that will produce the same results using two different methods in the WHERE Clause. Explain why the results are same.
• Include screenshot of code (no extra whitespace)
• Include screenshot of code result (no extra whitespace)
   

5. Create a QUERY: 

• Choose a table that has a column containing null values and a first and last name column.
• Then, write a query to display the column with NULL values and their name.  Include only rows with NULL values.
• Include screenshot of code (no extra whitespace)

Include screenshot of code result (no extra whitespace)