Data Table Table Name: TRADES DATE FIRM SYMBOL SIDE QUANTITY PRICE 2/3/2014 1ABC A123 B 200...
Data Table
Table Name: TRADES
|
DATE |
FIRM |
SYMBOL |
SIDE |
QUANTITY |
PRICE |
|
2/3/2014 |
1ABC |
A123 |
B |
200 |
41 |
|
2/4/2014 |
2BCD |
B234 |
B |
600 |
60 |
|
2/7/2014 |
1ABC |
C345 |
S |
600 |
70 |
|
2/10/2014 |
3CDE |
C345 |
S |
600 |
70 |
|
2/12/2014 |
4DEF |
B234 |
B |
200 |
62 |
|
2/14/2014 |
3CDE |
B234 |
B |
300 |
61 |
|
2/21/2014 |
1ABC |
A123 |
B |
300 |
40 |
|
2/24/2014 |
1ABC |
A123 |
S |
300 |
30 |
|
2/25/2014 |
4DEF |
C345 |
B |
2100 |
71 |
|
2/27/2014 |
CDE |
B234 |
S |
1100 |
63 |
Q3. Your business user asks you to tell them the unique firm and symbol combinations in the data table above.
- Please write the SQL query you would use to query this table.
- Please show the exact results you expect based on your SQL query.
Homework Answers
Required SQL Query is:
SELECT DISTINCT FIRM, SYMBOL FROM TRADES;
We use the keyword Distinct to select unique combinations of
firm and symbol from the table.
The output will be as follows:
| FIRM | SYMBOL |
| 1ABC | A123 |
| 2BCD | B234 |
| 1ABC | C345 |
| 3CDE | C345 |
| 4DEF | B234 |
| 3CDE | B234 |
| 4DEF | C345 |
| CDE | B234 |
Add Answer to:
Data Table
Table Name: TRADES
DATE
FIRM
SYMBOL
SIDE
QUANTITY
PRICE
2/3/2014
1ABC
A123
B
200...
1) Use the following data for a firm to assess solvency: 2013 BALANCE SHEETS 2016 2014...
1) Use the following data for a firm to assess solvency: 2013 BALANCE SHEETS 2016 2014 2017 2015 Cash & Equivalents 2$ 100 $ 90 $ 75 $ 100 $ 75 600 S Accounts Receivable %24 500 $ 550 S 300 400 S Inventory 250 $ 250 S 350 S 250 S 150 Gross Fixed Assets 900 $ 900 S 900 S 800 S 700 Accumulated Depreciation (335) S (260) S (190) S (125) $ (75) Total Assets 1,415 $...
Proft Price Number of writes gvenpien Total Total Warpiel Total Fued toduction Revenue Avenue Cost l...
Proft Price Number of writes gvenpien Total Total Warpiel Total Fued toduction Revenue Avenue Cost l P 1Q T Coast Coast Cast Coast Coast TCTC+TIC TOO TGIR 0 $80 180 0 2 0 1 2 3 4 5 120 9 12 0 $ 0 160 $80 400 120 720 ERO $960 O 1.1 20 0 31200 0 0 $300 3300 3200 200 $300 $300 5300 $150 $300 $450 $600 $750 300 3 00 M $ $75 $600 +750 150 $900...
2.Based on the demand and cost data for a pure monopolist given in the table below,...
2.Based on the demand and cost data for a pure monopolist given in the table below, answer the following questions -------------------------------------------------------------------------------------------------------------- Output 0 1 2 3 4 5 Price ($) 1000 600 500 400 300 200 Total Cost 500 520 580 700 1000 1500 -------------------------------------------------------------------------------------------------------------- a. Calculate the marginal revenue and marginal cost for this monopolist. b. How many units of output will the profit-maximizing monopolist produce? At what price? c. If this is a perfectly discriminating monopolist and he...
QUESTION 3 Figure Price Supply P K I P" P B M N Demand Quantity Refer...
QUESTION 3 Figure Price Supply P K I P" P B M N Demand Quantity Refer to Figure. If the government imposes a tax size of P- P" in the above market then the area L+M+Y represents a. consumer surplus after the tax. producer surplus after the tax. Cconsumer surplus before the tax. producer surplus before the tax. QUESTION 4 4 point Figure Supply Dennd Quantity Q1 02 Q3 Q Qs Refer to Figure. If the government impose a tax...
Chap 11 Practice: Costs, Profits and Profit Maximization Price Number of wortes given Total dudon Q...
Chap 11 Practice: Costs, Profits and Profit Maximization Price Number of wortes given Total dudon Q Total Revenue PQ War Revenue IMQ Tal Fed Costs TEC Tetable Cost TVC Total Costs TVC Au Varble Cont TV Are Maria Cost Coast 1000 1000 given C TC-TR 0 $80 1801 2 803 330 320 320 6 $ 0 $300 0 5300 N 2 3160 $80 3199 $150 $450 $ 3 525 $ $2.10 5 Shop 12033005300 6602 $60.120.50 $200 9 7200...300 $450...
please help asap and please show all work. thank you! table 1 data for 7075-T6 below...
please help asap and please show all work. thank you!
table 1 data for 7075-T6 below
table 2 data for 7075-T6 below
i
added the tables. they correspond within the pictures
2) Using data from Table A.1 and A.2, for Aluminum 7075-T6, for given a stress amplitude d+460 MPa a. What are the ELASTIC strain amplitude and the PLASTIC strain amplitude? b. What is the TOTAL strain amplitude? c. Draw accurately to scale, the o-e hysteresis loop for this load...
Q2. Retrieve the names of all employees from the employee table to produce output on CSV...
Q2. Retrieve the names of all employees from the employee table to produce output on CSV format or delimited format with a common delimeter, rather than separete columns. Hint:Put the whole row into a string with a semicolon as the seperator(delimeter) between thecolumns: FORMAT:(fname;minit;lname) Example: EMPLOYEES -------------- James;E;Borg Frank;T;Wong Q3. Write a query to show the employees name from the employee table in this format: first letter of the first name, followed by a dot, a blank, and the full...
2 of 2 (1 complete) - X - the adjusti mation.) Data Table the explanati Avery...
2 of 2 (1 complete) - X - the adjusti mation.) Data Table the explanati Avery Air Purification System Unadjusted Trial Balance December 31, 2024 of the services ecorded this Account Title Balance Debit Credit 7.700 Cash $ 19 200 2.300 1,200 19,800 e unadjusted trid $ dit 4,100 3,000 2.200 Accounts Receivable Prepaid Rent Office Supplies Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries Payable Unearned Revenue Common Stock Dividends Service Revenue Salaries Expense Rent Expense Depreciation Expense-Equipment Advertising Expense Supplies...
х i Data Table F G 1 2 3 4 B С D E Moore's Landscaping...
х i Data Table F G 1 2 3 4 B С D E Moore's Landscaping Services Worksheet December 31, 2024 Unadjusted Trial Balance Adjustments Debit Credit Debit Credit $ 27,200 6400 $ 5.000 650 S380 2.960 (a) 1480 52.000 Adjusted Trial Balance Debit 5 Account Names Credit US 000 (c) 1.200 78.000 1300 6 Cash 7 Accounts Receivable 8 Office Supplies 9 Prepaid Rent 10 Equipment Accumulated Depreciation- 11 Equipe 12 Trucks 13 Accumulated Depreciation Tracks 14 Accounts Payable...
6 MILESTONE 2 (Due in Module 4) MILESTONE 3 (Due in Module 5) MILESTONE 1 (Due in Module 2) 7 9 Instructions Milestone 2 10 12 1. Contribution Margin COGM Schedule .5 Name Choose a price range and ca...
6 MILESTONE 2 (Due in Module 4) MILESTONE 3 (Due in Module 5) MILESTONE 1 (Due in Module 2) 7 9 Instructions Milestone 2 10 12 1. Contribution Margin COGM Schedule .5 Name Choose a price range and calculate Grooming Create a Cost of Goods Manufactured Sched Location Vision Day Care Mission Bcarding 2. 2. 2. Break-Even Analysis Identify the following Create an Income Statement Calculate the break-even units Revenue will be provided end of week 4 Direct Materials Grooming...
1) Use the following data for a firm to assess solvency: 2013 BALANCE SHEETS 2016 2014 2017 2015 Cash & Equivalents 2$ 100 $ 90 $ 75 $ 100 $ 75 600 S Accounts Receivable %24 500 $ 550 S 300 400 S Inventory 250 $ 250 S 350 S 250 S 150 Gross Fixed Assets 900 $ 900 S 900 S 800 S 700 Accumulated Depreciation (335) S (260) S (190) S (125) $ (75) Total Assets 1,415 $...
Proft Price Number of writes gvenpien Total Total Warpiel Total Fued toduction Revenue Avenue Cost l P 1Q T Coast Coast Cast Coast Coast TCTC+TIC TOO TGIR 0 $80 180 0 2 0 1 2 3 4 5 120 9 12 0 $ 0 160 $80 400 120 720 ERO $960 O 1.1 20 0 31200 0 0 $300 3300 3200 200 $300 $300 5300 $150 $300 $450 $600 $750 300 3 00 M $ $75 $600 +750 150 $900...
QUESTION 3 Figure Price Supply P K I P" P B M N Demand Quantity Refer to Figure. If the government imposes a tax size of P- P" in the above market then the area L+M+Y represents a. consumer surplus after the tax. producer surplus after the tax. Cconsumer surplus before the tax. producer surplus before the tax. QUESTION 4 4 point Figure Supply Dennd Quantity Q1 02 Q3 Q Qs Refer to Figure. If the government impose a tax...
Chap 11 Practice: Costs, Profits and Profit Maximization Price Number of wortes given Total dudon Q Total Revenue PQ War Revenue IMQ Tal Fed Costs TEC Tetable Cost TVC Total Costs TVC Au Varble Cont TV Are Maria Cost Coast 1000 1000 given C TC-TR 0 $80 1801 2 803 330 320 320 6 $ 0 $300 0 5300 N 2 3160 $80 3199 $150 $450 $ 3 525 $ $2.10 5 Shop 12033005300 6602 $60.120.50 $200 9 7200...300 $450...
please help asap and please show all work. thank you!
table 1 data for 7075-T6 below
table 2 data for 7075-T6 below
i
added the tables. they correspond within the pictures
2) Using data from Table A.1 and A.2, for Aluminum 7075-T6, for given a stress amplitude d+460 MPa a. What are the ELASTIC strain amplitude and the PLASTIC strain amplitude? b. What is the TOTAL strain amplitude? c. Draw accurately to scale, the o-e hysteresis loop for this load...
2 of 2 (1 complete) - X - the adjusti mation.) Data Table the explanati Avery Air Purification System Unadjusted Trial Balance December 31, 2024 of the services ecorded this Account Title Balance Debit Credit 7.700 Cash $ 19 200 2.300 1,200 19,800 e unadjusted trid $ dit 4,100 3,000 2.200 Accounts Receivable Prepaid Rent Office Supplies Equipment Accumulated Depreciation-Equipment Accounts Payable Salaries Payable Unearned Revenue Common Stock Dividends Service Revenue Salaries Expense Rent Expense Depreciation Expense-Equipment Advertising Expense Supplies...
х i Data Table F G 1 2 3 4 B С D E Moore's Landscaping Services Worksheet December 31, 2024 Unadjusted Trial Balance Adjustments Debit Credit Debit Credit $ 27,200 6400 $ 5.000 650 S380 2.960 (a) 1480 52.000 Adjusted Trial Balance Debit 5 Account Names Credit US 000 (c) 1.200 78.000 1300 6 Cash 7 Accounts Receivable 8 Office Supplies 9 Prepaid Rent 10 Equipment Accumulated Depreciation- 11 Equipe 12 Trucks 13 Accumulated Depreciation Tracks 14 Accounts Payable...
6 MILESTONE 2 (Due in Module 4) MILESTONE 3 (Due in Module 5) MILESTONE 1 (Due in Module 2) 7 9 Instructions Milestone 2 10 12 1. Contribution Margin COGM Schedule .5 Name Choose a price range and calculate Grooming Create a Cost of Goods Manufactured Sched Location Vision Day Care Mission Bcarding 2. 2. 2. Break-Even Analysis Identify the following Create an Income Statement Calculate the break-even units Revenue will be provided end of week 4 Direct Materials Grooming...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago