Consider the following schema:
product (pname, price, category, manufacturer)
Purchase (buyer, seller, store, product)
Company (cname, stock price, country)
Person(per-name, phone number, city)
Write a suitable SQl for the following:
Ex #1: Find people who bought telephony products.
Ex #2: Find names of people who bought American products
Ex #3: Find names of people who bought American products and they live in Seattle.
Ex #4: Find people who have both bought and sold something.
Ex #5: Find people who bought stuff from Joe or bought products from a company whose stock prices is more than $50.
In: Computer Science
The following selected transactions relate to investment
activities of Ornamental Insulation Corporation during 2021. The
company buys debt securities, not intending to profit from
short-term differences in price and not necessarily to hold debt
securities to maturity, but to have them available for sale in
years when circumstances warrant. Ornamental’s fiscal year ends on
December 31. No investments were held by Ornamental on December 31,
2020.
| Mar. | 31 | Acquired 7% Distribution Transformers Corporation bonds costing $520,000 at face value. | ||
| Sep. | 1 | Acquired $1,080,000 of American Instruments’ 9% bonds at face value. | ||
| Sep. | 30 | Received semiannual interest payment on the Distribution Transformers bonds. | ||
| Oct. | 2 | Sold the Distribution Transformers bonds for $557,000. | ||
| Nov. | 1 | Purchased $1,560,000 of M&D Corporation 5% bonds at face value. | ||
| Dec. | 31 | Recorded any necessary adjusting entry(s) relating to the investments. The market prices of the investments are: |
| American Instruments bonds | $ | 1,018,000 | |
| M&D Corporation bonds | $ |
1,640,000 |
In: Accounting
A person invests $6675.00 at 6.25% compounded semiannually on October 1, 2018. If simple interest is allowed for part of an interest conversion period, how much is the investment worth June 1, 2022?
In: Finance
A corporate bond matures on October 31, 2035. Its coupon rate is 5.00% and face value is $100. Its yield is 5.90%. How much is its price on June 3, 2020?
In: Finance
Rios Financial Co. is a regional insurance company that began operations on January 1, Year 1. The following transactions relate to trading securities acquired by Rios Financial Co., which has a fiscal year ending on December 31:
Record these transactions on page 10:
|
Year 1 |
||
| Feb. | 1. | Purchased 6,600 shares of Caldwell Inc. as a trading security at $43 per share plus a brokerage commission of $660. |
| May | 1. | Purchased 1,800 shares of Holland Inc. as a trading security at $46 plus a brokerage commission of $198. |
| July | 1. | Sold 3,430 shares of Caldwell Inc. for $41 per share less a $115 brokerage commission. |
| 31. | Received an annual dividend of $0.25 per share on Caldwell Inc. stock. | |
| Dec. | 31. | The portfolio of trading securities was adjusted to fair values of $41 and $45 per share for Caldwell Inc. and Holland Inc., respectively. |
Record these transactions on page 11:
|
Year 2 |
||
| Apr. | 1. | Purchased 3,900 shares of Fuller Inc. as a trading security at $28 per share plus a $195 brokerage commission. |
| July | 31. | Received an annual dividend of $0.40 per share on Caldwell Inc. stock. |
| Oct. | 14. | Sold 780 shares of Fuller Inc. for $30 per share less a $45 brokerage commission. |
| Dec. | 31 | The portfolio of trading securities had a cost of $307,141 and a fair value of $385,878, requiring a debit balance in Valuation Allowance for Trading Investments of $78,737 ($385,878 - $307,141). Thus, the credit balance from December 31, Year 1, is to be adjusted to the new balance. |
| Required: | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1. | Journalize the entries to record these transactions. Round all final amounts to the nearest whole dollar.* | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 2. | Prepare the investment-related current asset balance sheet presentation for Rios Financial Co. on December 31, Year 2.* | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 3. | How are unrealized gains or losses
on trading investments presented in the financial statements of
Rios Financial Co.?
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
| raceethnicity |
COUNTA of raceethnicity |
| Arab-American | 3 |
| Asian/Pacific Islander | 21 |
| Black | 266 |
| Hispanic/Latino | 183 |
| Native American | 24 |
| Unknown | 22 |
| White | 574 |
| Grand Total | 1093 |
Perform a hypothesis test to examine the claim that the proportion of Hispanic/Latino people killed by police in the US is different from 16.4% (the 2014 demographic percentage for Hispanic/Latino Americans in the US population).
Clearly state the null and alternative hypotheses to test, both as sentences and using symbols.
Are the conditions (independent data and large enough sample size) met?
Use technology to calculate the test statistic and the P-value.
Make a sketch showing the distribution and the P-value.
Using significance level 0.05, do you reject the null hypothesis or not?
Communicate the conclusion of your hypothesis test in context.
2. Now perform a hypothesis test to examine the claim that the proportion of Black people killed by police in the US is different from 12.6% (the 2014 demographic percentage for Black Americans in the US population).Clearly state the null and alternative hypotheses to test, both as sentences and using symbols.
Are the conditions (independent data and large enough sample size) met?
Use technology to calculate the test statistic and the P-value.
Make a sketch showing the distribution and the P-value.
Using significance level 0.05, do you reject the null hypothesis or not?
Communicate the conclusion of your hypothesis test in context.
In: Statistics and Probability
Summarized data for Walrus Co. for its first year of operations are:
| $ |
.
In: Accounting
(CO G) List any five characteristics of joint ventures.
In: Finance
Describe Ethical Egoist view on co-operation and self-sacrifice
In: Psychology
What co-operation strategies should be adopted at the international level?
In: Economics