Homework Answers
From the table given
We need the output that contains the following
1. Account number with balance less than 50,000
2. The account balance of such accounts as mentioned in 1 above
Going by the needed output, the result would be
| Account # | Balance |
| BA-6 | 253 |
| BA-7 | 48000 |
| BA-9 | 950 |
| Account # | Type | Bank | Balance |
| BA-6 | Checking | Boston5 | 253 |
| BA-7 | Checking | Shawmut | 48000 |
| BA-9 | Checking | Boston5 | 950 |
Add Answer to:
Cash Table Account # Bank Balance BA-6 Type Checking Checking Boston5 253 BA-7 Shawmut 48,000 BA-8...
Using the Cash Table below, show the SQL command which will return accounts with only Checking...
Using the Cash Table below, show the SQL command which will
return accounts with only Checking type.
Cash
Account#
Type
Bank
Balance
BA-6
Checking
Boston5
253
BA-7
Checking
Shawmut
48,000
BA-8
Draft
Shawmut
75,000
BA-9
Checking
Boston5
950
Account # Bank Bank SELECT FROM WHERE
Using the Cash table below, show the output for the following SQL query: (Using the dropdowns,...
Using the Cash table below, show the output for the following
SQL query: (Using the dropdowns, identify which rows and
columns would included in the SQL query output shown below. Select
"Not included" for rows and columns that would not be included in
the output.)
SELECT Account#, Balance
FROM Cash
WHERE Bank = ‘Boston5’
ORDER BY Amount DESC;
Cash Account # Type Bank Balance 253 48.000 75,000 950 Checking Checking Draft Checking ncluded BA-6 BA-7 ot Included BA-8 BA-9 Boston...
On October 31, 2021, the bank statement for the checking account of Blockwood Video shows a balance of $12,742, while t...
On October 31, 2021, the bank statement for the checking account of Blockwood Video shows a balance of $12,742, while the company's records show a balance of $12,336. Information that might be useful in preparing a bank reconciliation is as follows: a. Outstanding checks are $1,235. b. The October 31 cash receipts of $790 are not deposited in the bank until November 2. C. One check written in payment of utilities for $138 is correctly recorded by the bank but...
85) 6 Saved Help El Gato Painting Company maintains a checking account at American Bank. Bank...
85) 6 Saved Help El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: $3,321 1,290 Balance per bank, November 30 Add: Deposits outstanding Less: Checks outstanding #363 #365 #380 #381 #382 Adjusted balance per bank, November 30 $ 132 210 65 95 430 as (932) $3,679 The company's general ledger checking account showed the following for...
Oscar’s Red Carpet Store maintains a checking account with Academy Bank. Oscar’s sells carpet each day...
Oscar’s Red Carpet Store maintains a checking account with Academy Bank. Oscar’s sells carpet each day but makes bank deposits only once per week. The following provides information from the company’s cash ledger for the month ending February 28, 2021. Date Amount No. Date Amount Deposits: 2/4 $ 2,350 Checks: 321 2/2 $ 4,350 2/11 1,950 322 2/8 650 2/18 2,850 323 2/12 2,150 2/25 3,750 324 2/19 1,850 Cash receipts: 2/26-2/28 1,250 325 2/27 450 $ 12,150 326 2/28...
Answer all questions The statement Like "A?9 can be used as a query criterion to match...
Answer all questions
The statement Like "A?9 can be used as a query criterion to match several field values. List any one example of a field value that would match this criterion. 3. What specific type of query would use the following criterion? Like [Enter name:] & 4. What aggregate function would be used to output the number of nonnull field values in a crosstab query? 5. 6. The value Is Null would be used as a criterion in which...
Cash and Other Items The following information has been extracted from Atwood Corporation's accounting records: Cash...
Cash and Other Items The following information has been extracted from Atwood Corporation's accounting records: Cash on hand (undeposited sales receipts) Certificates of deposit Customer's note receivable Reconciled balance in University National Bank checking account Reconciled balance in Second National Bank checking account Balance in City Federal savings account Customer's postdated check Employee travel advances $ 1,535 25,000 1,000 (350) 9,260 7,410 980 1,200 Cash in bond sinking fund 8,300 Bond sinking fund investments 14,600 Required: 1. Determine the balance...
SLLALTUnenens Exercise 7-9 This information relates to the Cash account in the ledger of Oriole Company Balance S...
SLLALTUnenens Exercise 7-9 This information relates to the Cash account in the ledger of Oriole Company Balance September 1-$20,570; Cash deposited-$64,000 Balance September 30-$21,770; Checks written-$62,800 The September bank statement shows a balance of $20,670 at September 30 and the following memoranda. Credits Collection of electronic funds transfer Debits NSF check: H. Kane $2,400 $1,130 Interest earned on checking account 60 Safety deposit box rent 75 At September 30, deposits in transit were $5,323 and outstanding checks totaled $2,968. Prepare...
Use the following to answer questions 5-8 Bank Reconciliation: Identify whether the item should be added...
Use the following to answer questions 5-8 Bank Reconciliation: Identify whether the item should be added or subtracted from the bank balance or the company balance. Use the number 1-4) for your response. For instance, if the amount should be added to bank statement balance you would input 1. 1. Added to bank statement balance 2. Subtracted from bank statement balance 3. Added to company cash balance 4. Subtracted from company cash balance 6 7 8 Item Bank deducted too...
Date 7/1 7/15 7/22 7/30 8/1 8/10 8/17 9/21 10/17 12/15 GREAT ADVENTURES Cash Account Records...
Date 7/1 7/15 7/22 7/30 8/1 8/10 8/17 9/21 10/17 12/15 GREAT ADVENTURES Cash Account Records July 1, 2021, to December 31, 2021 Cash Receipts Cash Disbursements Desc. Amount Date Check# Desc. Stock sale $ 30,000 7/1 101 Insurance Clinic receipts 1,800 7/2 102 Legal fees clinic receipts 2,760 7/7 DC Advertising clinic receipts 3,600 7/8 103 Bikes Borrowing 26,000 7/24 DC Advertising clinic receipts 5,100 8/4 104 Kayaks clinic receipts 11,900 8/24 Office supplies Clinic receipts 12,800 9/1 105...
Using the Cash Table below, show the SQL command which will
return accounts with only Checking type.
Cash
Account#
Type
Bank
Balance
BA-6
Checking
Boston5
253
BA-7
Checking
Shawmut
48,000
BA-8
Draft
Shawmut
75,000
BA-9
Checking
Boston5
950
Account # Bank Bank SELECT FROM WHERE
Using the Cash table below, show the output for the following
SQL query: (Using the dropdowns, identify which rows and
columns would included in the SQL query output shown below. Select
"Not included" for rows and columns that would not be included in
the output.)
SELECT Account#, Balance
FROM Cash
WHERE Bank = ‘Boston5’
ORDER BY Amount DESC;
Cash Account # Type Bank Balance 253 48.000 75,000 950 Checking Checking Draft Checking ncluded BA-6 BA-7 ot Included BA-8 BA-9 Boston...
On October 31, 2021, the bank statement for the checking account of Blockwood Video shows a balance of $12,742, while the company's records show a balance of $12,336. Information that might be useful in preparing a bank reconciliation is as follows: a. Outstanding checks are $1,235. b. The October 31 cash receipts of $790 are not deposited in the bank until November 2. C. One check written in payment of utilities for $138 is correctly recorded by the bank but...
85) 6 Saved Help El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: $3,321 1,290 Balance per bank, November 30 Add: Deposits outstanding Less: Checks outstanding #363 #365 #380 #381 #382 Adjusted balance per bank, November 30 $ 132 210 65 95 430 as (932) $3,679 The company's general ledger checking account showed the following for...
Answer all questions
The statement Like "A?9 can be used as a query criterion to match several field values. List any one example of a field value that would match this criterion. 3. What specific type of query would use the following criterion? Like [Enter name:] & 4. What aggregate function would be used to output the number of nonnull field values in a crosstab query? 5. 6. The value Is Null would be used as a criterion in which...
Cash and Other Items The following information has been extracted from Atwood Corporation's accounting records: Cash on hand (undeposited sales receipts) Certificates of deposit Customer's note receivable Reconciled balance in University National Bank checking account Reconciled balance in Second National Bank checking account Balance in City Federal savings account Customer's postdated check Employee travel advances $ 1,535 25,000 1,000 (350) 9,260 7,410 980 1,200 Cash in bond sinking fund 8,300 Bond sinking fund investments 14,600 Required: 1. Determine the balance...
SLLALTUnenens Exercise 7-9 This information relates to the Cash account in the ledger of Oriole Company Balance September 1-$20,570; Cash deposited-$64,000 Balance September 30-$21,770; Checks written-$62,800 The September bank statement shows a balance of $20,670 at September 30 and the following memoranda. Credits Collection of electronic funds transfer Debits NSF check: H. Kane $2,400 $1,130 Interest earned on checking account 60 Safety deposit box rent 75 At September 30, deposits in transit were $5,323 and outstanding checks totaled $2,968. Prepare...
Use the following to answer questions 5-8 Bank Reconciliation: Identify whether the item should be added or subtracted from the bank balance or the company balance. Use the number 1-4) for your response. For instance, if the amount should be added to bank statement balance you would input 1. 1. Added to bank statement balance 2. Subtracted from bank statement balance 3. Added to company cash balance 4. Subtracted from company cash balance 6 7 8 Item Bank deducted too...
Date 7/1 7/15 7/22 7/30 8/1 8/10 8/17 9/21 10/17 12/15 GREAT ADVENTURES Cash Account Records July 1, 2021, to December 31, 2021 Cash Receipts Cash Disbursements Desc. Amount Date Check# Desc. Stock sale $ 30,000 7/1 101 Insurance Clinic receipts 1,800 7/2 102 Legal fees clinic receipts 2,760 7/7 DC Advertising clinic receipts 3,600 7/8 103 Bikes Borrowing 26,000 7/24 DC Advertising clinic receipts 5,100 8/4 104 Kayaks clinic receipts 11,900 8/24 Office supplies Clinic receipts 12,800 9/1 105...
Most questions answered within 3 hours.
-
Group Policies
Research GROUP POLICY OBJECTS (GPO'S)
You can start in the Windows Server 2012 eBook...
asked 3 minutes ago -
software engineering
Problems.
Create a use case diagram for class registration for a
university.
Create a...
asked 2 minutes ago -
You are trying to convince your friend who wants to attend
medical school to take BY123...
asked 18 minutes ago -
Subject: C++
I have created a class called QueueOfIntegers in a file called
QueueOfIntegers.h, which is...
asked 17 minutes ago -
calculate the number of molecules of gas in a
container of 2.0 liter at 30 degrees...
asked 35 minutes ago -
1.which of the following is a phototroph?
a. sulfolobus
b. chloroflexus
c. bacteroidetes
d. deinococcus radioduran...
asked 31 minutes ago -
The group of companies LC "High-precision measuring instruments"
is the global provider of measurement, analysis and...
asked 37 minutes ago -
I want to write a python function to find the minimum
I have an nested list:...
asked 37 minutes ago -
Convert the high level language programming statementts to 80x86
assembly, Assume X=AX and y=BX
for (i=1;...
asked 46 minutes ago -
SoleMate’s Burkins sneakers cost $40 per pair from the supplier
and are sold by SoleMate at...
asked 50 minutes ago -
The movie Moneyball (based on the book by Michael
Lewis) tells the story of Billy Beane,...
asked 49 minutes ago -
A regional highway uses 8 tollbooths that are open to all
vehicles. A chi-square goodness-of-fit test...
asked 52 minutes ago