“SELECT” command: The “SELECT” command is used to retrieve data in a database . Syntax for selecting values from the table is as follows: SELECT STUDENT_ID FROM STUDENT; The given query is used to display each student ID from “STUDENT” table. Naming the computed column in SQL: User can assign a name to the computation by using below ways: Name the computation with the word “AS”. User desired name. Example: The example for naming the computed column in SQL is shown below: SELECT STUDENT_ID, STUDENT_NAME, MAXIMUM_LIMIT – SCORE AS STUDENT_CREDIT FROM STUDENT; The above query is used to display student id, student name and student credit from “STUDENT” table. STUDENT_ID STUDENT_NAME STUDENT_CREDIT 123 Merry 90 208 John 86 408 Rose 98 564 Joseph 78 Explanation: User can compute the student credit using the expression “MAXIMUM_LIMIT – SCORE”. From the given query, the computation is calculated by using “-” operator that is from “MAXIMUM_LIMIT – SCORE”. Here the computed result is name as “STUDENT_CREDIT” by using the word “AS”.

Question

Need help answering these questions!1. Design a While loop that lets the user enter a number. The number should be multiplied by 10, and the result stored in a variable named product. The loop should iterate as long as the product contains a value less than 100. 2. Design a For loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 . . . 1000 3. Convert the While loop in the following code to a Do-While loop: Declare Integer x = 1 While x > 0 Display "Enter a number." Input x End While

Answer 1

Question

Chapter 4, Problem 10SCG

Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT STUDENT_ID FROM STUDENT;

The given query is used to display each student ID from “STUDENT” table.

Naming the computed column in SQL:

User can assign a name to the computation by using below ways:

Name the computation with the word “AS”.

User desired name.

Example:

The example for naming the computed column in SQL is shown below:

SELECT STUDENT_ID, STUDENT_NAME, MAXIMUM_LIMIT – SCORE AS STUDENT_CREDIT FROM STUDENT;

The above query is used to display student id, student name and student credit from “STUDENT” table.

STUDENT_ID STUDENT_NAME STUDENT_CREDIT
123 Merry 90
208 John 86
408 Rose 98
564 Joseph 78

Explanation:

User can compute the student credit using the expression “MAXIMUM_LIMIT – SCORE”.

From the given query, the computation is calculated by using “-” operator that is from “MAXIMUM_LIMIT – SCORE”.

Here the computed result is name as “STUDENT_CREDIT” by using the word “AS”.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Need help answering these questions!1. Design a While loop that lets the user enter a number. The number should be multiplied by 10, and the result stored in a variable named product. The loop should iterate as long as the product contains a value less than 100. 2. Design a For loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 . . . 1000 3. Convert the While loop in the following code to a Do-While loop: Declare Integer x = 1 While x > 0 Display "Enter a number." Input x End While

Need help with these:Design a While loop that lets the user enter a number. The number should be multiplied by 10, and the result stored in a variable named product. The loop should iterate as long as the product contains a value less than 100. 2. Design a For loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 . . . 1000 3. Convert the While loop in the following code to a Do-While loop: Declare Integer x = 1 While x > 0 Display "Enter a number." Input x End While

Convert the While loop in the following code to a Do-While loop: Declare Integer x = 1 While x > 0 Display "Enter a number." Input x End While