REP RATE COMMISSION STATE ZIP CITY FIRST NAME STREET REP LAST NUM NAME $20,542.50 0.05 33321 FL 624 Randall Grove Kaiser Valerie 20 $39,216.00 0.07 33553 FL Sheldon Richard 532 Jackson 35 Hull $23,487.00 0.05 33336 1626 Taylor Fillmore FL Perez 65 Juan CUSTOMER CREDIT BALANCE STATE ZIP REP LIMIT NUM CITY CUSTOMER STREET CUSTOMER NUM NAME $6,550.00 $7,500.00 20 Al's Appliance and Sport Fillmore 33336 FL 148 2837 Greenway $431.50 $10,000.00 35 Grove Brookings Direct 33321 282 3827 Devon FL $5,785.00 $7,500.00 65 33503 $5,285.25 $5,000.00 35 382 Wildwood Northfield FL 356 Ferguson's 33146 The FL 408 Crystal 1828 Raven Everything Shop Bargains Galore 3829 Central Grove FL $3,412.00 $10,000.00 65 462 33321 Kline's 838 Ridgeland Fillmore 524 33336 $12,762.00 $15,000.00 20 FL 372 Oxford Johnson's Sheldon 608 FL $2,106.00 $10,000.00 65 33553 Department Store 282 Evergreen Altonville FL Lee's Sport and Appliance 687 32543 $2,851.00 $5,000.00 35 282 Columbla Sheldon Deerfield's 725 FL $248.00 $7,500.00 35 33553 Four Seasons All Season 28 Lakevlew 842 Grove FL $8,221.00 $7,500.00 20 33321 ORDERS ORDER_LINE CUSTOMER ORDER ORDER_ ORDER NUM PART NUM NUM ORDERED QUOTED_PRICE NUM NUM DATE АТ94 21608 11 $21.95 10/20/2007 148 21608 21610 DR93 $495.00 1 10/20/2007 356 21610 21610 DW11 1 $399.99 10/21/2007 408 21613 21613 KL62 4 $329,95 10/21/2007 282 21614 КТоЗ 21614 $595.00 2 10/23/2007 608 21617 BV06 21617 $794.95 2 10/23/2007 148 21619 21617 $150.00 CD52 4 10/23/2007 608 21623 DR93 $495.00 21619 1 21623 $1,290.00 2 KV29 Iub PART PART NUM DESCRIPTION ON HAND CLASS WAREHOUSE PRICE 50 HW $24.95 AT94 Iron 3 45 SG $794.95 2 Home Gym BV06 CD52 $165.00 Microwave Oven 32 AP 1 21 HW Cordless Drill $129.95 DL71 3 8 AP $495.00 DR93 Gas Range 2 Washer DW11 3 $399.99 12 AP FD21 $159.95 Stand Mixer 22 HW 3 Dryer KL62 $349.95 12 AP 1 Ктоз 8 AP Dishwasher $595.00 3 KV29 Treadmill $1,390.00 9 SG 2

Question

What is the SQL command for the following, using the data attached:

Find the total of the balances for all customers represented by sales rep 65 with balances that are less than their credit limits. 

REP
RATE
COMMISSION
STATE ZIP
CITY
FIRST
NAME
STREET
REP LAST
NUM NAME
$20,542.50 0.05
33321
FL
624 Randall
Grove
Kaiser Valerie
20
$39,216.00 0.07
33553
FL
Sheldon
Richard 532 Jackson
35
Hull
$23,487.00 0.05
33336
1626 Taylor Fillmore FL
Perez
65
Juan
CUSTOMER
CREDIT
BALANCE
STATE ZIP
REP
LIMIT NUM
CITY
CUSTOMER
STREET
CUSTOMER
NUM
NAME
$6,550.00 $7,500.00 20
Al's Appliance
and Sport
Fillmore
33336
FL
148
2837
Greenway
$431.50 $10,000.00 35
Grove
Brookings
Direct
33321
282
3827 Devon
FL
$5,785.00 $7,500.00 65
33503 $5,285.25 $5,000.00 35
382 Wildwood Northfield FL
356
Ferguson's
33146
The
FL
408
Crystal
1828 Raven
Everything
Shop
Bargains
Galore
3829 Central Grove
FL
$3,412.00 $10,000.00 65
462
33321
Kline's
838 Ridgeland Fillmore
524
33336 $12,762.00 $15,000.00 20
FL
372 Oxford
Johnson's
Sheldon
608
FL
$2,106.00 $10,000.00 65
33553
Department
Store
282 Evergreen Altonville FL
Lee's Sport
and Appliance
687
32543 $2,851.00 $5,000.00 35
282 Columbla Sheldon
Deerfield's
725
FL
$248.00 $7,500.00 35
33553
Four Seasons
All Season
28 Lakevlew
842
Grove
FL
$8,221.00 $7,500.00 20
33321
Expand
Transcribed Image Text

REP RATE COMMISSION STATE ZIP CITY FIRST NAME STREET REP LAST NUM NAME $20,542.50 0.05 33321 FL 624 Randall Grove Kaiser Valerie 20 $39,216.00 0.07 33553 FL Sheldon Richard 532 Jackson 35 Hull $23,487.00 0.05 33336 1626 Taylor Fillmore FL Perez 65 Juan CUSTOMER CREDIT BALANCE STATE ZIP REP LIMIT NUM CITY CUSTOMER STREET CUSTOMER NUM NAME $6,550.00 $7,500.00 20 Al's Appliance and Sport Fillmore 33336 FL 148 2837 Greenway $431.50 $10,000.00 35 Grove Brookings Direct 33321 282 3827 Devon FL $5,785.00 $7,500.00 65 33503 $5,285.25 $5,000.00 35 382 Wildwood Northfield FL 356 Ferguson's 33146 The FL 408 Crystal 1828 Raven Everything Shop Bargains Galore 3829 Central Grove FL $3,412.00 $10,000.00 65 462 33321 Kline's 838 Ridgeland Fillmore 524 33336 $12,762.00 $15,000.00 20 FL 372 Oxford Johnson's Sheldon 608 FL $2,106.00 $10,000.00 65 33553 Department Store 282 Evergreen Altonville FL Lee's Sport and Appliance 687 32543 $2,851.00 $5,000.00 35 282 Columbla Sheldon Deerfield's 725 FL $248.00 $7,500.00 35 33553 Four Seasons All Season 28 Lakevlew 842 Grove FL $8,221.00 $7,500.00 20 33321

ORDERS
ORDER_LINE
CUSTOMER
ORDER ORDER_
ORDER NUM PART NUM NUM ORDERED QUOTED_PRICE
NUM
NUM
DATE
АТ94
21608
11
$21.95
10/20/2007 148
21608
21610
DR93
$495.00
1
10/20/2007 356
21610
21610
DW11
1
$399.99
10/21/2007 408
21613
21613
KL62
4
$329,95
10/21/2007 282
21614
КТоЗ
21614
$595.00
2
10/23/2007 608
21617
BV06
21617
$794.95
2
10/23/2007 148
21619
21617
$150.00
CD52
4
10/23/2007 608
21623
DR93
$495.00
21619
1
21623
$1,290.00
2
KV29
Iub
PART
PART NUM DESCRIPTION
ON HAND CLASS WAREHOUSE PRICE
50 HW
$24.95
AT94
Iron
3
45 SG
$794.95
2
Home Gym
BV06
CD52
$165.00
Microwave Oven
32 AP
1
21 HW
Cordless Drill
$129.95
DL71
3
8 AP
$495.00
DR93
Gas Range
2
Washer
DW11
3
$399.99
12 AP
FD21
$159.95
Stand Mixer
22 HW
3
Dryer
KL62
$349.95
12 AP
1
Ктоз
8 AP
Dishwasher
$595.00
3
KV29
Treadmill
$1,390.00
9 SG
2
Expand
Transcribed Image Text

ORDERS ORDER_LINE CUSTOMER ORDER ORDER_ ORDER NUM PART NUM NUM ORDERED QUOTED_PRICE NUM NUM DATE АТ94 21608 11 $21.95 10/20/2007 148 21608 21610 DR93 $495.00 1 10/20/2007 356 21610 21610 DW11 1 $399.99 10/21/2007 408 21613 21613 KL62 4 $329,95 10/21/2007 282 21614 КТоЗ 21614 $595.00 2 10/23/2007 608 21617 BV06 21617 $794.95 2 10/23/2007 148 21619 21617 $150.00 CD52 4 10/23/2007 608 21623 DR93 $495.00 21619 1 21623 $1,290.00 2 KV29 Iub PART PART NUM DESCRIPTION ON HAND CLASS WAREHOUSE PRICE 50 HW $24.95 AT94 Iron 3 45 SG $794.95 2 Home Gym BV06 CD52 $165.00 Microwave Oven 32 AP 1 21 HW Cordless Drill $129.95 DL71 3 8 AP $495.00 DR93 Gas Range 2 Washer DW11 3 $399.99 12 AP FD21 $159.95 Stand Mixer 22 HW 3 Dryer KL62 $349.95 12 AP 1 Ктоз 8 AP Dishwasher $595.00 3 KV29 Treadmill $1,390.00 9 SG 2

Expert Answer

1 Rating

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Engineering
Computer Science

Databases

Related Computer Science Q&A

Find answers to questions asked by students like you.

Q: what is a router?

A: Router:A router is a physical or virtual tool for receiving, processing and transferring incoming pa...

Q: Create a new Python program (you choose the filename) that contains a main function and another func...

A: Programimport randomdef changelist(myList)middleLsit=myList[3:9]print"The size of the list is now ",...

Q: PLEASE EXPLAIN ALL STEPSIn the following code, determine the value of the symbole this. Predict and ...

A: Explanation of given code:“this” is a variable.DECO this, d; The instruction DECO means Decimal outp...

Q: I need help with this in python. I'm not understanding it

A: To solve this Question following variables and functions have been used:Variables: Arce, landsz, tot...

Q: In Python use the Design Recipe to write a function,  count_odds, that consumes a list and two integ...

A: Program Instructions:Write the function header and type contrast of the program.Write description an...

Q: C++ program   This assignment is about array operations. Create an array with 1000 items and fill it...

A: Create a C++ program and initialize a macro N with value 1000.In the main method declare an array "a...

Q: First, launch NetBeans and close any previous projects that may be open (at the top menu go to File ...

A: Program Instructions:Declare the initial balance to $5000.Use do-while loop to repeatedly show the m...

Q: Within the NTDS folder, which file stores the main Active Directory database? Group of answer choice...

A: Within the NTDS folder, the “Ntds.dit”file stores the main Active Directory database .Hence, option ...

Q: I need help programming this problem in C++   Given an array of N elements, what is the average numb...

A: Linear Search:Take the array of N number of elements. Best case:Assume, that the search element is a...

Q: Python 3.7.4 Define a function called signOf that takes a parameter containing an integer value and ...

A: Function definition of "signOf()":

Q: Create the following classes based on the given declaration. Also, each class should have the defaul...

A: Program DescriptionSince variables of vector type are to be declared we include the vector header fi...

Q: The essential condition of third normal form is automatically satisfied whenA) a table has only one ...

A: To solve this question a user have to know the definition of Third Normal Form (3NF):Third Normal Fo...

Q: I need help creating a trace table

A: Create a Trace Table and assign all required values according to the code. And if a variable is only...

Q: First, launch NetBeans and close any previous projects that may be open (at the top menu go to File ...

A: Following are the steps to create the java application Rooter that simulates the working of ATM:Crea...

Q: What 1s the output of the following code! { String myStr = new String("Cheggers2019") ; System.out.p...

A: There seems to be some error in the question, hence we are proceeding with a small assumption on our...

Q: Draw a decision tree and find the number of key comparisons in the worst and average cases for the t...

A: Decision tree (enhanced bubble sort):

Q: The class RoachPopulation simulates the growth of a roach population.The constructor takes the size ...

A: Program code #1:

Q: I have to code the game mastermind, but i only got halfway. I got the user input, 8 colors and the 3...

A:  solving the duplication problem:Create a temporary array named "temp" and initiate that array with ...

Q: What is the RAND Report? Why was it developed? What was published in the RAND Report R-609?Why was i...

A: RAND Report:RAND reports consist of findings from the profound research and objective analysis which...

Q: Write three statements to print the first three elements of vector runTimes. Follow each with a newl...

A: A vector called runTime has to store 5 elements. This program prompts the user to enter the 5 elemen...

Q: Which of the following diagrams do not contradict the current state of our knowledge about the compl...

A: P class problems can be solved in deterministic polynomial time. NP class can be verified in the pol...

Q: Hey i need help with coding in c++  Q1 // with steps  Write a program that determines a student’s gr...

A: Approach for the program- 1)Import the essential headers.2)Define the main function.3)Declare the va...

Q: Assignment First, launch NetBeans and close any previous projects that may be open (at the top menu ...

A: A Java program that satisfies the given criteria is given below,Program://Import necessary packagesi...

Q: Python 3.7.4 Write the code to call a function whose name is send_number. There is one argument for ...

A: Source Codedef send_number(n):    #getting the value 5 from the function call.  print("The value of ...

Q: I am getting a floating point exception in my code. Which is to divide matrix 1 by matrix 2 (striaig...

A: Program Instructions:A floating-point exception occurs when an attempt is made to divide a number by...

Q: Hello! I am new to Java and am struggling heavily with a current assignment. I got the output to loo...

A: Program: import java.util.Scanner;import java.math.RoundingMode;import java.text.DecimalFormat;publi...

Q: Arrays Write a for loop to print all elements in courseGrades, following each element with a space (...

A: Programming instructions: First, initialize the variable which takes the size of the array and an ar...

Q: in python 2.2Write a program that prompts the user for two inputs: the unit cost of an item and the ...

A: round() function is used to round the number.Syntax of round function:round(number [, ndigit])number...

Q: In Lab 2, you created a menu for a simple calculator program. In Lab 6, you added some functionality...

A: Program Algorithm-STARTStep1 Import essential headers.Step2 Define main functionStep3 Print “Hello u...

Q: A bag of cookies holds 40 cookies. The calorie information on the bag claims that there are 10 servi...

A: Program AlgorithmDeclare the required variable in the main().Get the input from the user for the num...

Q: I need help with this C++ problem.    Assume that a binary search function is searching for a value ...

A: Binary search: - It is a technique used to search an element in a sorted array.It is also known as h...

Q: Write the MIPS assembly code that corresponds to the pseudo codebelow. Assume that the address for i...

A: MIPS instruction:The full form of MIPS is Million Instructions Per Second.The speed of computer’s pr...

Q: Apply backtracking to the problem of finding a Hamiltonian circuit in the graph below:

A: Hamilton circuit, also called as Hamilton cycle forms a close loop by visiting each node exactly onc...

Q: Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using ...

A: In the crow’s foot notation, entities are displayed in a box with the attributes listed below the na...

Q: Python 3.7.4 Given that add, a function that expects two int parameters and returns their sum, and g...

A: The statement is given below,eurasia_sales = add(euro_sales, asia_sales)

Q: A domain controller clone is a replica of an existing DC. Group of answer choices True False

A: Domain Controller:Domain controller is a server computer on Microsoft servers.The purpose of domain ...

Q: Security challenges of social networking sites

A: Security challenges of Social Network WebsitesSocial EngineeringIt involves techniques used by hacke...

Q: I dont understand how theyre getting the answers to the output public class MysteryWho {public stati...

A: The output of the given program is:

Q: consider the sender A transmits 12 data packets to b using stop wait protocol. if every 3rd packet i...

A: The all data transmission in send and wait protocol as follows:If packet loss, retransmit packet.Ini...

Q: Python 3.7.4 Open the file hostdata.txt for reading.

A: To open the file hostdata.txt for reading, the statement is: f=open('hostdata.txt','r')The following...

Q: Please Use JAVA to solve the problem

A: Create a java class “ArrayInv” and create a main method inside it.And declare a required variable to...

Q: OF 2019 x + X PG Difference between two given ti https://moodle.oakland.edu/plug X fn Course: CSI-14...

A: Program in C to calculate the order price by entering number of books, price of a book, tax per book...

Q: Databse SQL Queries. Need to write the SQL code for pulling the total cost of our inventory. We have...

A: A SQL query is to be written that will give the total cost of inventory. Two tables are given named ...

Q: Python 3.7.4 Write the code to call the function named send_signal. There are no parameters for this...

A: To call the given function without parameter we need to write it as send_signal(). The following is ...

Q: EXPLAIN ALL STEPS: Determine the output of the following Pep/9 machine language program. The left co...

A: In this question our first duty is to discuss what is pep/9:pep/9:Pep/9 CPU simulator for use with C...

Q: Create a GUI interface for a currency converter - Dollar-to-Euro. It should look something like the ...

A: To create a GUI converter that converts the currency from dollar to euro below is the approach and j...

Q: Design a reasonably efficient algorithm for solving each of the following problems and determine its...

A: Algorithm to find who failed to pay telephone billFor finding who failed to pay telephone bill, firs...

Q: Suppose you have two tables: EMPLOYEE and EMPLOYEE_1. The EMPLOYEE table contains the records for th...

A: Two tables are given named as EMPLOYEE and EMPLOYEE1. Each table has its records. EMPLOYEE table has...

Q: Create a new file (in Dev C++) and save it as lab10_XYZ.cpp (replace XYZ with your initials). In La...

A: C++ programThe code for calculator programs is#include <iostream>using namespace std;void disp...

Q: a. Show that the disk moves made in the classic recursive algorithm for the Towers of Hanoi puzzle c...

A: a.Disk moves for Tower of Hanoi puzzle The disk moves that are made in the classic recursive algorit...