Styjun

Why is Ian Blackford allowed to speak in the Commons while having crossed the line?

Python Curses input screen

Kitchen rewire gone wrong

Where is a celebration-free, little-to-no Christmas skiing destination during the holiday season?

Calculating with directlua in Plain LuaTeX

Filling an arc when using relative coordinates

What are the correct pronouns for referring to someone whom I have never met in person when the gender is apparent?

How to deal with complaints about you - if you warned against the risk?

Why do many names of technical and scientific subjects end with "ics"?

Why there are no major political movements worried about asteroid/comet impact?

Backwards Alphabet Triangle

Why does it seem everything I push moves at a constant velocity?

Unbalanced dollar signs

How to make vehicular combat viable in a Post Apocalyptic world?

I shall Keep Watch for My Family

Urgently need pre-paid debit card to pay debt collector

Do dams reduce the flow of river downstream?

During World War 1, were any policies in place to handle large scale troop mutiny?

Sum of all matrix entries

How to call my own phone with a loud ringing tone (in order to find it in my house) even if it is in silent mode?

Busted my bike hub & derailleur (I think) - how bad is it?

What is the value of the "Texas Crutch"?

Creating a network with coordinate and link data

Biological Use of FOOF

WHERE is not valid in this position, expecting identifier

Are (non-void) self-closing tags valid in HTML5?MySQL Syntax Error on Table CreationWHERE using a temporary tablePostgres excludes NULL in WHERE id != int queryHow to search from varchar column with - on itCast a new column and then cross compare to another table in where statementHow to check an ascending ordered column value in where clause in postgresql?Referencing ROW_NUMBER() in WHERESQL WHERE clause not functional with stringIs main a valid Java identifier?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

0

HW Question: Create a table of all the customers in Massachusetts. The table should contain the customer’s name (with the column header “Customer Name”), customer number (with the column header “Customer Number”), city, and state (in that order). The table rows should be in alphabetical order by city.
Hints: for this query, use the WHERE command. For example, if we wanted all the customers in the United States, we would include country = “USA” as part of the query. To order the data, use the ORDER BY command. For example, “ORDER BY postalCode” would order the table by zip code. Copy and paste your final query below:

Here is the code I wrote, which is fine until I get to the WHERE. SQL says WHERE is not valid at this position, needs an identifier. I have no idea what that means. Any help is much appreciated.

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

I tried moving around the parenthesis, semi-colons, lines from one WHERE line to two

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

I need this to create a table output with column headers and rows ordered in alphabetical order by city

syntax where identifier

share|improve this question

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You seem to be confusing 1) creating the table and 2) retrieving data with a query. They're unrelated.
  
  – melpomene
  Mar 28 at 21:29
  

  
  
  
  

add a comment
 | 

0

HW Question: Create a table of all the customers in Massachusetts. The table should contain the customer’s name (with the column header “Customer Name”), customer number (with the column header “Customer Number”), city, and state (in that order). The table rows should be in alphabetical order by city.
Hints: for this query, use the WHERE command. For example, if we wanted all the customers in the United States, we would include country = “USA” as part of the query. To order the data, use the ORDER BY command. For example, “ORDER BY postalCode” would order the table by zip code. Copy and paste your final query below:

Here is the code I wrote, which is fine until I get to the WHERE. SQL says WHERE is not valid at this position, needs an identifier. I have no idea what that means. Any help is much appreciated.

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

I tried moving around the parenthesis, semi-colons, lines from one WHERE line to two

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

I need this to create a table output with column headers and rows ordered in alphabetical order by city

syntax where identifier

share|improve this question

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You seem to be confusing 1) creating the table and 2) retrieving data with a query. They're unrelated.
  
  – melpomene
  Mar 28 at 21:29
  

  
  
  
  

add a comment
 | 

HW Question: Create a table of all the customers in Massachusetts. The table should contain the customer’s name (with the column header “Customer Name”), customer number (with the column header “Customer Number”), city, and state (in that order). The table rows should be in alphabetical order by city.
Hints: for this query, use the WHERE command. For example, if we wanted all the customers in the United States, we would include country = “USA” as part of the query. To order the data, use the ORDER BY command. For example, “ORDER BY postalCode” would order the table by zip code. Copy and paste your final query below:

Here is the code I wrote, which is fine until I get to the WHERE. SQL says WHERE is not valid at this position, needs an identifier. I have no idea what that means. Any help is much appreciated.

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

I tried moving around the parenthesis, semi-colons, lines from one WHERE line to two

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

I need this to create a table output with column headers and rows ordered in alphabetical order by city

syntax where identifier

share|improve this question

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

USE classicmodels;
CREATE TABLE CUSTOMERS_MA (
customerName varchar(225) NOT NULL,
customerNumber varchar(225) NOT NULL,
city varchar(225) NOT NULL,
state varchar(225) NOT NULL,
WHERE customerName = 'Customer Name' and customerNumber = 'Customer Number',
ORDER BY city);

share|improve this question

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1

share|improve this question

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

edited Mar 28 at 21:32

jmoerdyk

4,90677 gold badges3030 silver badges4040 bronze badges

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1

asked Mar 28 at 21:25

Jocelyn RJocelyn R

1