Reference no: EM13856315
Write the SQL command to complete each step.
Create a database with two tables: Customers (Cust_ID, First, Last, Balance, CreditLimit, Rep_ID) and Sales_Rep (Rep_ID, Rep_First, Rep_Last, Per_Hour). For simplicity, use Short text for data type except when you can use currency.
1. List the Cust_IDs and names of all customers.
2. List the Cust_Id and name of every customer represented by sales rep 35.
3. List the number and name of all customers that are represented by sales rep 35 and that have credit limits of $10,000.
4. List the number and names of all customers represented by a rep whose last name starts with Per.
5. Find the total and average balances for all customers
6. List all customer last names whose balance is above the credit limit.
7. Calculate the total weekly wages if all sales reps are working for 40 hrs. per week.
8. Add a new customer (45, Jim, Jones, 4000, 5000, 35)
9. List all customer last names corresponding with the last names of their sales reps, sorted by customer last names in ascending order.
10. Update the customer's last name to Newlywed if the Cust_ID is 282
|
A description of the technology
: 1) A description of the technology 2) describe challenges that Googlecould face in implementing this technology 3) suggestions for overcoming someof the potential challenges and obstacles
|
|
The relationship database for the lucky rent-a-car
: The relationship database for the lucky Rent-A-Car example described earlier. There is a one- to-many relationship from manufacturers to cars and another one- to- many relationship from cars to maintenance events. The former requires the manufact..
|
|
What is the value of infix expression 5
: a. What is the value of infix expression 5 + (4 - 2 * 3 ) * 5 + 6 ? b. Show step by step (draw it out) to change the above infix expression to postfix expression using a Stack, you need to show the contents of stack and Output
|
|
Types of knowledge-based decision support systems
: Applying change management theory to discuss the integration of one of the four types of knowledge-based decision support systems
|
|
Write the sql command to complete each step
: Write the SQL command to complete each step. Create a database with two tables: Customers (Cust_ID, First, Last, Balance, CreditLimit, Rep_ID) and Sales_Rep (Rep_ID, Rep_First, Rep_Last, Per_Hour). For simplicity, use Short text for data type except ..
|
|
Blue-ocean strategy-merger and acquisition
: A blue-ocean strategy: All firms are subject to offensive challenges from rivals. The intent of the best defensive move is to: What does the scope of the firm refer to? The difference between a merger and an acquisition relates to: What outcomes do h..
|
|
Explain what he saying here about he aim of yoga
: A short quotation from Sri Aurobindo appears on p. 92 of Religions of Asia Today. Explain what he's saying here about he aim of yoga, especially the relationship between personal experience and universal Truth
|
|
Accounting for share transactions
: The shareholder's equity section of the consolidated balance sheet of CompX international appeared as follows at the beginning of the year:
|
|
Data and images
: Lossless and lossy are the two (2) universally known categories of compression algorithms. Compare the two (2) categories of algorithms, and determine the major advantages and disadvantages of each. Provide one (1) example of a type of data for which..
|