Computers and Technology, 12.06.2020 07:57 kekeke68

PLEASE HELP ASAP! WILL MARK BRAINLIEST IF THE ANSWER IS CORRECT! I NEED HELP WITH THE 3RD ONE! Using the premiere database create the following SQL queries:
1.Display all information from the customer table for all customers that have a balance that is greater than the average balance.
SELECT * FROM customer WHERE customer. balance > (SELECT avg(customer. balance) FROM customer)
2.Display all information from the rep table for all representatives that have a rate which is equal to the minimum rate for representatives.
SELECT * FROM `rep` WHERE `rate` = (SELECT MIN(rate) from rep)
3.Display each unique description and price (no duplicates) for all parts that have a quoted price that is greater than the average quoted price for all parts ordered.
???

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 17:30

Rachel completed typing an official document with a word processing program. she wants to make sure that her document has no typographical errors. she also wants all headings to have the same font. which features in a word processing program should she use? rachel should use the feature in a word processing program to find typographical errors. she should apply to have uniform headings.

Answers: 1

Answer

Computers and Technology, 22.06.2019 20:00

The blank button automatically displays next to the data when you select a range of numeric data which is an available option for creating a chart

Answers: 3

Answer

Computers and Technology, 23.06.2019 09:50

Allison and her group have completed the data entry for their spreadsheet project. they are in the process of formatting the data to make it easier to read and understand. the title is located in cell a5. the group has decided to merge cells a3: a7 to attempt to center the title over the data. after the merge, allison points out that it is not centered and looks bad. where would the title appear if allison unmerged the cells in an attempt to fix the title problem?

Answers: 2

Answer

Computers and Technology, 23.06.2019 18:20

What is wi-fi infrastructure? a metropolitan area network that uses radio signals to transmit and receive data a communications technology aimed at providing high-speed wireless data over metropolitan area networks a means by which portable devices can connect wirelessly to a local area network, using access points that send and receive data via radio waves includes the inner workings of a wi-fi service or utility, including the signal transmitters, towers, or poles and additional equipment required to send out a wi-fi signal

Answers: 2

Answer

You know the right answer?

PLEASE HELP ASAP! WILL MARK BRAINLIEST IF THE ANSWER IS CORRECT! I NEED HELP WITH THE 3RD ONE! Usin...

Questions