SQL problems. Please help

Use Priemiere Products database to complete the following exercise.

9. Use a subquery to find the rep number, last name, and first name of each sales rep who represents

at least one customer with a credit limit of $10,000. List each sales rep only once

in the results.

10. Repeat Exercise 9, but this time do not use a subquery.

11. Find the number and name of each customer that currently has an order on file for a

Gas Range.

12. List the part number, part description, and item class for each pair of parts that are in the

same item class. (For example, one such pair would be part AT94 and part FD21, because

the item class for both parts is HW.)

13. List the order number and order date for each order placed by the customer named

Johnson

Write a method that accepts a string object as an argument and returns the number of words it contains. for instance, if the argument is "four score and seven years ago", the method should return the number 6. demonstrate the method in a program that asks the user to input a string and then passes that string into the method, printing out whatever the method returns.

Identify the publisher in this citation: carter,alan.a guide to entrepreneurship.new york: river’2008.print.

Local area networks use many of the same network technologies and the internet, only on a smaller scale. devices that access lans are equipped with a network interface that contains circuitry for wireless or wired connections. devices also have a physical address, in addition to the ip addresses acquired from a dhcp server. the most popular wired technology is . the most popular wireless technology is , which can be configured as a(n) or star topology. setting up a lan and configuring its router is fairly easy. the first step is to change the standard to one that is secure. next, create a(n) that uniquely identifies the network by name. it is also important to activate wireless to prevent wireless signals from being intercepted during transmission. a limited-access network can be created for visitors to use. by activating , the router will be able to assign ip addresses to each device that joins the network. to connect to a secure lan that is protected by encryption, an encryption , or password, is required. lans can be used to access data collected by iot devices and the networks that tie these devices together. technologies such as rfid, nfc, bluetooth smart, zigbee, and z-wave offer -power links, essential for battery-powered devices that can’t expend excess amounts of energy transmitting data.