Textbook Problem

List the names of all customers that have a credit limit of $7,500 or less.

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;

Explanation of Solution

SQL code:

The SQL code used to list the customer name whose credit limit is “$7500” or less is as follows:

SELECT CUSTOMER_NAME FROM CUSTOMER WHERE CREDIT_LIMIT < = 7500;

Explanation:

The above query list the “CUSTOMER_NAME” whose credit limit is less than or equal to “$7500”.

Sample Output

Output:

Screenshot of output