× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
j
3
s
3
j
2
J
2
e
2
n
2
t
2
d
2
b
2
t
2
J
2
b
2
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
asourdillard asourdillard
wrote...
Go to Answer
Posts: 639
Rep: 0 0
6 years ago
Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand?
 a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICEFROM PRODUCT;
 b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICEFROM PRODUCT;
 c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOHP_PRICEFROM PRODUCT;
 d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICEFROM PRODUCT;
Read 78 times
1 Reply
Replies
Answer verified by a subject expert
babyfacelovebabyfacelove
wrote...
#1
Top Poster
Posts: 903
Rep: 8 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

asourdillard Author
wrote...

6 years ago
Thanks
mikey3091
wrote...

Yesterday
Thanks
MLynneMcMillan
wrote...

2 hours ago
this is exactly what I needed
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  796 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 381
  
 145
  
 228
Your Opinion
Previous poll results: Who's your favorite biologist?