subject
Computers and Technology, 04.08.2021 14:00 bbtor

By Using the following schema, answer the following SQL queries and commands: Product(P_code. P_name, P_price, P_on_hand, vend_code) Vender(vend_code, vend_fname, vend_areacode, vend_phone) 1- find the venders names who sell products in TN-5 area and their names include "dan". 2- find the code, name and vender code of product that has price between 1500S and 2500S and the product that has price between 48005 and 5600S. 3- Find the name, and code of venders who had 5 microwaves that has price less than 3500S. 4- Find the phone numbers of venders who sell Televisions. 5- Delete the records of venders who their first name is 'smith'

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 11:00
Which are examples of note-taking tools? check all that recording devices sticky notes digital highlighters paper flags highlighting pens digital displays digital flags
Answers: 1
question
Computers and Technology, 22.06.2019 16:20
Octothorpe is another name for what common computer keyboard symbol?
Answers: 1
question
Computers and Technology, 23.06.2019 03:00
What are the different parts of computer
Answers: 2
question
Computers and Technology, 23.06.2019 20:00
Match the file formats with the types of multimedia they can store
Answers: 2
You know the right answer?
By Using the following schema, answer the following SQL queries and commands: Product(P_code. P_name...
Questions
question
Mathematics, 11.02.2022 01:20
question
English, 11.02.2022 01:20
question
Mathematics, 11.02.2022 01:20
question
English, 11.02.2022 01:20
question
Chemistry, 11.02.2022 01:20
question
Social Studies, 11.02.2022 01:20
Questions on the website: 13722361