All categories

3 years ago

Write a SELECT statement that returns these columns from the Customers table:

Computers and Technology

1 answer:

Nastasia [14]3 years ago

3 0

Answer:

SELECT customer_last_name, customer_city, customer_zip FROM customers WHERE customer_state = 'IL' ORDER BY customer_last_name DESC;

Explanation:

Here, we are given a SCHEMA with the table name customers.

It's creation command and commands to insert values are also given.

We have to print the customer last name, city and zip code of all the customers who have their state as IL in the decreasing order of their last names.

Let us learn a few concepts first.

1. To print only a specified number of columns:

We can write the column names to be printed after the SELECT command.

2. To print results as per a condition:

We can use WHERE clause for this purpose.

3. To print in descending order:

We can use ORDER BY clause with the option DESC to fulfill the purpose.

Therefore, the answer to our problem is:

SELECT customer_last_name, customer_city, customer_zip FROM customers WHERE customer_state = 'IL' ORDER BY customer_last_name DESC;

Output of the command is also attached as screenshot in the answer area.

You might be interested in

You have been allocated a class C network address of 211.1.1.0 and are using the default subnet mask of 255.255.255.0 how many h

Aneli [31]

Answer:thats is so easy obviously 69

Explanation:

6 0

3 years ago

What is the effects of computer and internet attacks

ZanzabumX [31]

Answer:

ads, damage, or bugs

Explanation:

7 0

3 years ago

Read 2 more answers

Which two statements are true about algorithms?

DENIUS [597]

Answer:

I. Algorithms can be written using pseudocode.

II. Algorithms can be visualized using flowcharts.

Explanation:

An algorithm can be defined as a standard formula or procedures which comprises of set of finite steps or instructions for solving a problem on a computer. The time complexity is a measure of the amount of time required by an algorithm to run till its completion of the task with respect to the length of the input.

The two statements which are true about algorithms are;

I. Algorithms can be written using pseudocode. A pseudocode refers to the description of the steps contained in an algorithm using a plain or natural language.

II. Algorithms can be visualized using flowcharts. A flowchart can be defined as a graphical representation of an algorithm for a process or workflow.

Basically, a flowchart make use of standard symbols such as arrows, rectangle, diamond and an oval to graphically represent the steps associated with a system, process or workflow sequentially i.e from the beginning (start) to the end (finish).

3 0

3 years ago

Read 2 more answers

____________ occurs when a provider does not support data export or when a provider's service is unavailable through others.

elixir [45]

Answer:

The correct answer to the following question will be Vendor Lock-In.

Explanation:

Vendor Lock-In: It is also known as Customer Lock-In. The Vendor Lock-In makes the costumer depends on services and products on the vendor. The costumers are not able to use another vendor without changing costs as it creates barriers.

Some ways to avoid Vendor Lock-In, these are as follows:

Design your application portable.
Keep watching vendor contracts.
Arrange both entry and exit with your vendor.

8 0

3 years ago

Create two classes. The first, named Sale, holds data for a sales transaction. Its private data members include the day of the m

olya-2409 [2.1K]

Answer:

A C++ program was used in creating two classes. the code is stated below.

Explanation:

Solution

The C++ program is executed below:

#include<iostream>

using namespace std;

//declare class (will be define later)

class Salesperson;

//class Sale

class Sale

{

//private members of class

private:

string day;

double amtOfSale;

int salesPersonId;

//public methods

public:

//constructor that takes day,amount of sale and salesPersonId as parameters

Sale(string date,double sale,int id)

{

//set the private members to the initial values passed

day=date;

amtOfSale=sale;

salesPersonId=id;

}

//declare a friend function that takes objects of the two classes as parameters

friend void display(Sale,Salesperson);

};

//define class Salesperson

class Salesperson

{

//private members of the class

private:

int salesPersonId;

string lastName;

//public methods

public:

//constructor that takes name and id as parameters

Salesperson(int id,string name)

{

//set the members of the class with the parameters passed

salesPersonId=id;

lastName=name;

}

//declare a friend function that takes objects of the two classes as parameters

friend void display(Sale,Salesperson);

};

//define the friend funtion

void display(Sale saleObj,Salesperson personObj)

{

//display the sales info using the objects of the two classes

cout<<"\nSale #"<<saleObj.salesPersonId<<" on "<<saleObj.day<<" for $"<<saleObj.amtOfSale<<" sold by #"<<personObj.salesPersonId<<" "<<personObj.lastName;

}

int main()

{

//create object for Sale class and pass default values

Sale sObj1("12/25/2016",559.95,103);

//create object for Salesperson class and pass default values

Salesperson pObj1(103,"Woods");

//create another object for Sale class and pass default values

Sale sObj2("11/15/2016",359.95,106);

//create another object for Salesperson class and pass default values

Salesperson pObj2(106,"Hansen");

//using the friend function dislay the sales info

display(sObj1,pObj1);

display(sObj2,pObj2);

return 0;

}

4 0

4 years ago