Project the all columns from the
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
Which program was your database created in?
I think xxx
it makes a difference for the syntax
I have more question
ok, the way this site works is that you ask one question at a time, and when you receive your answer you rate the expert
you will then have an opportunity to ask me more questions
via my profile
but lets address your first question
the suppliers 802 and 803
what is the column heading that is comming from?
yes, that is a typical query
but we need to know the column name
that the xxx and xxx are in
so it works correctly
I was trying this way but it wouldn't work
i know why
and can help you fix it
can you tell me what the column name is
or all of the other 800 numbers
just need the name of the column
the xxxxxxx xxxxx xxxxx
will have a list of all of the column names
that I couldn't find the question is just like that
do you have a copy of the actual database?
I can send you the whole question
ok, lets try that
Question 1 [3pts possible]:
xxxxxx Xxxxx xxxxx xxxx xx xxx xxxxxx xxxxx; xxxxxxxx xxxxxxx xxxxxx xxx xxxx Xxxxxx.'
-- SELECT *
xxx(10)+'xxxxxxx, xxx xxxx x, xxxxxxx Xxx [3pts possible]:
xxxxxxxxx xxxxxxx xxxx xxxx xxxxxxxxx xxx and xxxx.
Use the OR condition in your WHERE clause.'
Project the all columns from the xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx
Use the IN condition in your WHERE clause.'
xxxxxxx xxxxxxx xxxxxx xxxx;
Show the name and title for all employees with an EmpID value less than 6:'
Display the invoice number and customer ID for all records in the INVOICE table which have a TotalPrice
value less than $100; sort the results by customer ID (in descending order).'
--SELECT INVOICE NUMBER, CUSTOMER ID
Show the Type and Version of every stove in the STOVE table - except the ones which are RED or BLUE.
Sort your results in order of Type, then Version; eliminate duplicate values.'
-- SELECT TYPE, VERSION
Show the invoice number and total price from the INVOICE table for all of the invoices for customer number 125.
List them in order of invoice date, and re-name the columns using AS.'
-- [Insert your code here]
Get the information for all invoices which have a total price between $100 and $200 (inclusive); show the invoice
number, total price, and employee number. Order the output by invoice number.'
xxxxxxxxxxxxxxxxx xxxxxxxx xxxxxxxxx xxx x x x
(hint: use LIKE and a wildcard).'
did you get it?
that is all the info you have
beacuse this is practially impossible without the actual db
your original question would normally look like this in sql
SELECT * Fxxxxx xxxx xxxxx xxxxxxxx'
what we need is what columnname is
so i cannot give you complete SQL queries until we get all of the information, or a copy of the database
if you would like to get that information
then get back to me
Iwould be happy to help you then
how about the other question?
can you help me please?
let me see which ones I can help with
Display each StateProvince value in the CUSTOMER table; eliminate duplicate values in your results.'
xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx
number 1 and 4 I gat the answer
3 was the one where we needed more info
okay can you please try the rest of the question?
Sxxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx
List them in order of invoice date, and re-name the columns using AS
SELECT invoice number, total price, employee number FROM whateverthetablenameis WHERE total price >=100 AND total price <= 200 ORDER BY invoice number ASC
good so far?
let me get you 9 and 10
then you can pay me
xxxxxx xxxxx xxx xxxxxxxxxxx xxxx x x xxxx xxxx xxx xxxxx (i.e. the Description value begins
with either of those two words - use LIKE and a wildcard to match).'
every time the 1000s place changes
you want a blue bottom border across the row
and you want that to be done with macro
is this correct so far?
sorry wrong question
working on yours but someone else contacted me at the same time
that should do it for you
PLEASE REMEMBER TO RATE MY SERVICE USING THE SMILEYS BENEATH THIS CHAT
BONUS ALSO APPRECIATED
how much is that?
the cost of the question was $45
that was the value you selected
rating will not cost you anything additional
you have the option of adding a bonus if you wish
if you think I did an exceptionally good job
you already the money right?
not until you rate
that is how the site works
the smiley faces underneath this chat
is how you do that
I don't understand can you explain me please this is my firs time so
this link explains it all
do I have to decide how much you can get?
I am not sure what you see on your screen, I only am a contractor. I do not get paid until you rate using the smileys below this chat
if you are still confused
I can send the question to customer service
or you can contact them at
Need help? Call our Toll-Free Customer Service
US/Canada 1.888.862.9212 Available 6am to 6pm PST
InternationalAvailable 24/7 for calls from outside US/Canada:
Australia 1800-679-634 New Zealand 0800-452-621 United Kingdom 0808-189-0970 The rest of the world 1-925-418-3893
I will rate excellent