Write a SELECT statement that returns these columns from the Customers table:
Customer last name customer_last name column
City customer_city column
Zip code customer_zip Column
Return only the rows with customer_state equal to IL .
Sort the results in Descending order of customer last name
SCHEMA:
CREATE TABLE customers
(
customer_id INT NOT NULL,
customer_last_name VARCHAR(30),
customer_first_name VARCHAR(30),
customer_address VARCHAR(60),
customer_city VARCHAR(15),
customer_state VARCHAR(15),
customer_zip VARCHAR(10),
customer_phone VARCHAR(24)
);
INSERT INTO customers VALUES
(1, 'Anders', 'Maria', '345 Winchell Pl', 'Anderson', 'IN', '46014', '(765) 555-7878'),
(2, 'Trujillo', 'Ana', '1298 E Smathers St', 'Benton', 'AR', '72018', '(501) 555-7733'),
(3, 'Moreno', 'Antonio', '6925 N Parkland Ave', 'Puyallup', 'WA', '98373', '(253) 555-8332'),
(4, 'Hardy', 'Thomas', '83 d''Urberville Ln', 'Casterbridge', 'GA', '31209', '(478) 555-1139'),
(5, 'Berglund', 'Christina', '22717 E 73rd Ave', 'Dubuque', 'IA', '52004', '(319) 555-1139'),
(6, 'Moos', 'Hanna', '1778 N Bovine Ave', 'Peoria', 'IL', '61638', '(309) 555-8755'),
(7, 'Citeaux', 'Fred', '1234 Main St', 'Normal', 'IL', '61761', '(309) 555-1914'),
(8, 'Summer', 'Martin', '1877 Ete Ct', 'Frogtown', 'LA', '70563', '(337) 555-9441'),
(9, 'Lebihan', 'Laurence', '717 E Michigan Ave', 'Chicago', 'IL', '60611', '(312) 555-9441'),
(10, 'Lincoln', 'Elizabeth', '4562 Rt 78 E', 'Vancouver', 'WA', '98684', '(360) 555-2680');
Answers
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.
Related Questions
Which of the following is NOT true?
a. The process provides the macro steps
b. Methodologies provide micro steps that never transcends the macro steps.
c. Methodologies provide micro steps that sometimes may transcend the macro steps.
d. A methodology is a prescribed set of steps to accomplish a task.
Answers
Answer:
b. Methodologies provide micro-steps that never transcends the macro steps.
Explanation:
Methodologies are a series of methods, processes, or steps in completing or executing a project. Projects can be divided into macro steps or processes and these macro steps can be divided into several micro-steps. This means that, in methodology, micro-steps always transcends to a macro-step.
Any one know??please let me know
Answers
Answer:
B
Explanation:
Answer:
The answer is B.
Explanation:
Also I see your using schoology, I use it too.
Pointers are addresses and have a numerical value. You can print out the value of a pointer as cout << (unsigned)(p). Write a program to compare p, p + 1, q, and q + 1, where p is an int* and q is a double*. Explain the results.
Answers
Answer:
#include <iostream>
using namespace std;
int main() {
int i = 2;
double j = 3;
int *p = &i;
double *q = &j;
cout << "p = " << p << ", p+1 = " << p+1 << endl;
cout << "q = " << q << ", q+1 = " << q+1 << endl;
return 0;
}
Explanation:
In C++, pointers are variables or data types that hold the location of another variable in memory. It is denoted by asterisks in between the data type and pointer name during declaration.
The C++ source code above defines two pointers, "p" which is an integer pointer and "q", a double. The reference of the variables i and j are assigned to p and q respectively and the out of the pointers are the location of the i and j values in memory.
3. Write a function named sum_of_squares_until that takes one integer as its argument. I will call the argument no_more_than. The function will add up the squares of consecutive integers starting with 1 and stopping when adding one more would make the total go over the no_more_than number provided. The function will RETURN the sum of the squares of those first n integers so long as that sum is less than the limit given by the argument
Answers
Answer:
Following are the program to this question:
def sum_of_squares(no_more_than):#defining a method sum_of_squares that accepts a variable
i = 1#defining integer variable
t = 0#defining integer variable
while(t+i**2 <= no_more_than):#defining a while loop that checks t+i square value less than equal to parameter value
t= t+ i**2#use t variable to add value
i += 1#increment the value of i by 1
return t#return t variable value
print(sum_of_squares(12))#defining print method to call sum_of_squares method and print its return value
Output:
5
Explanation:
In the program code, a method "sum_of_squares" is declared, which accepts an integer variable "no_more_than" in its parameter, inside the method, two integer variable "i and t" are declared, in which "i" hold a value 1, and "t" hold a value that is 0.
In the next step, a while loop has defined, that square and add integer value and check its value less than equal to the parameter value, in the loop it checks the value and returns t variable value.
A video game character can face one of four directions
Answers
I didn’t know that:)
Generally speaking, digital marketing targets any digital device and uses it to advertise and sell a(n) _____.
religion
product or service
governmental policy
idea
Answers
Answer:
product or service
Explanation:
Digital marketing is a type of marketing that uses the internet and digital media for the promotional purposes. It is a new form of marketing where the products are not physically present. The products and services are digitally advertised and are used for the popularity and promotion. Internet and digital space are involved in the promotion. Social media, mobile applications and websites are used for the purpose.
Answer:
A.) Product or service
Explanation:
Digital marketing is the practice of promoting products or services through digital channels, such as websites, search engines, social media, email, and mobile apps. The goal of digital marketing is to reach and engage with potential customers and ultimately to drive sales of a product or service. It can target any digital device that can access the internet, and it can use a variety of techniques such as search engine optimization, pay-per-click advertising, social media marketing, content marketing, and email marketing to achieve its objectives.
A series of gentle often open-ended inquiries that allow the client to progressively examine the assumptions and interpretations here she is made about the victimization experience is called:_____.
Answers
Answer:
Trauma Narrative
Explanation:
Given that Trauma narrative is a form of narrative or carefully designed strategy often used by psychologists to assists the survivors of trauma to understand the meaning or realization of their experiences. It is at the same time serves as a form of openness to recollections or memories considered to be painful.
Hence, A series of gentle often open-ended inquiries that allow the client to progressively examine the assumptions and interpretations he or she is made about the victimization experience is called TRAUMA NARRATIVE
