Category: Uncategorized

Use the following information to answer questions 5 through 7   Army Supply Company issued five-year, 7% bonds with a face value of $25,000 on January 1, 1722.  The effective rate of interest is 6%.  Army Supply sold the bonds for $26,053. The bonds pay annual interest each December 31. What is the amount of cash that Army Supply will pay to bond holders for interest in 1724?

On October 1, 2033, Cameron Equipment signed a one-year, 8% interest-bearing note payable for $50,000. Assuming Cameron Equipment maintains its books on a calendar year basis, how much interest expense should be reported in the 2033 income statement? Assume this is the only interesting bearing note.

Consider the below tables Clients Agents   Consider the query SELECT *FROM Clients cFULL OUTER JOIN Agents aON c.ClientID = a.ClientID;   Which  will show in the result?

Consider the below table.   The query  SELECT * FROM Songs2 WHERE Duration < 235 OR SongTitle LIKE '%e'    Would return how many results?  

Consider the below query:   SELECT ProductName,CASEWHEN Inventory 100 THEN ‘Overstocked’ELSE ‘Unknown’END AS InventoryStatusFROM Products;   What would the output be on a value of 103?

Consider the below query:   SELECT StudentName,CASEWHEN Grade > 60 THEN ‘D’WHEN Grade > 70 THEN ‘C’WHEN Grade > 80 THEN ‘B’WHEN Grade > 90 THEN ‘A’ELSE ‘F’END AS LetterGradeFROM Students;   What would the output be on a value of 91?

Consider the below table.   The query   SELECT * FROM Songs2 WHERE Duration < 235    Would return how many results?  

A company has a table called Employees with the columns: EmployeeIDEmployeeNameDivision Which query will count the number of employees in each division and return only the divisions that have at least 1000 employees?

Consider the below table.   Which query would select songs with a null duration?

Which of the below is used for multi line comments in SQL?