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;

Question

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.

Answer 1

Question

Chapter 8, Problem 1TD

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;

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

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.

For this portion of the lab design the solution in the following manner: Create a table using a two-dimensional list that stores a Fahrenheit temperature and the equivalent Celsius temperature. Use the following range of Fahrenheit temperatures:Starting at -10 through 100 in increments of 10. Thus, the Fahrenheit temperatures will be:-10, 0, 10, 20, 30, 40, 50…and so on.Display the contents of the list.Similarly create tables/lists for the following, starting at 0 through 100 in increments of 10:Miles to kilometersGallons to litersPounds to kilogramsInches to centimetersDisplay the contents of each listSave the program as firstname_lastname_Lab7a.py where you will replace firstname and lastname with your actual first and last name.

6. Delete all the records in "student" table. Enter your answer 7. Delete a record in "student" table where its id is 1. Enter your answer 8. Get only the "name" and "birthdate" of the "student" table where its "name" starts with "Jo" Enter your answer