SELECT statement: It is used to retrieve information from the table or database . The syntax for the “SELECT” statement is given below: Syntax: SELECT * FROM table_Name; “UPPER” keyword: The keyword “UPPER” is used to convert the string into capital letters that is, it converts the string into upper case letters. Syntax: SELECT UPPER (column_Name) FROM table_Name; “LOWER” keyword: The keyword “LOWER” is used to convert the string into small letters that is, it converts the string into lower case letters. Syntax: SELECT LOWER (column_Name) FROM table_Name;

Question

USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.

Answer 1

Question

Chapter 8, Problem 1SCG

Program Plan Intro

SELECT statement:

It is used to retrieve information from the table or database. The syntax for the “SELECT” statement is given below:

Syntax:

SELECT * FROM table_Name;

“UPPER” keyword:

The keyword “UPPER” is used to convert the string into capital letters that is, it converts the string into upper case letters.

Syntax:

SELECT UPPER (column_Name) FROM table_Name;

“LOWER” keyword:

The keyword “LOWER” is used to convert the string into small letters that is, it converts the string into lower case letters.

Syntax:

SELECT LOWER (column_Name) FROM table_Name;

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

USE NORTHWIND DATABASE Write a SELECT statement using the CASE function. The statement returns two columns basedon how many orders the customer has in the database. The first column is the customer name andthe second column, Membership Type, is based on which case applies to the customer:If the customer has more than 25 orders they are a Diamond Customer.If the customer has more than 15 orders they are a Gold Customer.If the customer has more than 10 orders they are a Silver Customer.If the customer has more than 5 orders they are an Iron Customer.Otherwise the customer is a Valued Customer.

fa table in a SQL database has a column of type `VARCHAR(100)", what does the "100" signify? a) The number of records that can be stored in the column. b) The number of unique characters that can be stored in the column. c) The maximum length of a string that can be stored in the column. d) The minimum length of a string that can be stored in the column.

Type Reduction in cell M1 The amount is 50% of sick days above 10, whenever sick days exceed 10. For all other records, the amount is 0 Create the criteria area, starting in cell P8 Enter formula(s) to complete column M, using an IF Statement.