![cdgood12](/avatars/47910.jpg)
cdgood12
20.11.2019 •
Computers and Technology
Sql dml query in mysql sql query from a single table is 4420, database fundamentals i. ddl we create the following tables in lecture 7 1. customer 2. product 3. orders 4. orderline ii. dml: insert data into tables use the code in lecture8.rtf to insert data iii. dml: query 1. list all data records for all four tables 2. list ids of products in descending order 3. list the cities (distinctly) for the customers 4. list all orderlines have quantity more or equals to 5 5. list all columns of product with the name that contains the string 'laptop 6. list customers who lived in city 'tucson 7. count the number of customers in each city. show the name of the city and corresponding count. 8. list all orders after and on 2008-11-01 9. list all orders between 2008-10-24 and 2008-11-01 inclusive (including both dates) 10. what is the average price for product that is more than $50? 11. list all customers who do not live salt lake city. 12. list all customers who are from slc and whose name starts with the letter 13. list all product ids that show more than twice in orderline table iv. deliverables 1. submit the lab8.txt file that contains your sql statements to canvas
Solved
Show answers
More tips
- S Style and Beauty How to Properly Apply Eye Makeup: Tips from a Professional Makeup Artist...
- A Animals and plants How ants survive winter: exploring the secrets of their winter life...
- F Food and Cooking Discover How to Properly Prepare Dough for Rasstegai...
- P Philosophy Unidentified Flying Object - What is the Nature of this Phenomenon?...
- F Family and Home Protect Your Home or Apartment from Pesky Ants...
- O Other What is a Disk Emulsifier and How Does it Work?...
- F Family and Home What does a newborn need?...
- F Family and Home Choosing the Right Car Seat for Your Child: Tips and Recommendations...
- F Food and Cooking How to Get Reconfirmation of Registration?...
- C Computers and Internet How to Get Rid of Spam in ICQ?...
Answers on questions: Computers and Technology
- C Computers and Technology When a ball is thrown vertically upward from a reference location, it travels to a maximum height and then changes direction and experiences a fall.Ignoring the air resistance and...
- C Computers and Technology What is the theoretical maximum capacity (in bps) for a wireless link, with spectrum ranging from 30GHz to 60GHz, and with an SNR of 20dB? (1 point)...
- C Computers and Technology Access Control can be defined as putting controls (or countermeasures) in place to help achieve information security goals. Which of the following information security goals can...
- C Computers and Technology Em hãy khai báo biến cho bài toán sau Viết chương trình nhập vào bán kính R. Tính độ dài đường kính (d), Chu vi (P), và bán kính (R) của đường tròn...
- H History Plz why did both the north and south mistakenly think that the civil war would be short? a. both sides had large groups of people who opposed the war. b. neither side realized how...
- M Mathematics Answer and explain these 3 questions. you!...
- E English Which propaganda technique promotes the idea that a belief or course of action is popular? bandwagon name-calling repetition scapegoating...
- B Biology In regard to the estuary conservation strategy involving the removal of contaminated substrate, which of these statements are true? select all that apply. a it is one of the least...
- A Arts The bell for the front door (is/are) out of order...
- M Mathematics Determine the measure of q in sin q =0.4848 to the nearest degree....
Ответ:
(A) A customer service representative uses a phone to talk to customers and resolve issues.
In general, an IT CSR’s major role is to provide help and answers via phone by providing customers’ technical issues through identification of problem, research and subsequent provision of guidance. This is an IT help desk who provides supportive role in cooperate environment.