First%20Exam%20Make%20Up%20Questions

First%20Exam%20Make%20Up%20Questions - St. Johns University...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
St. John’s University Tobin College of Business Accounting 3354 Accounting Information Systems Make Up Exam for Fall 2008 Your Name: Query 1: Now extract all stocks that begin with the letter H alphabetiacal order. Post query and the entire result grid here as above. This is a partial results table. Query 1 Trade Date Cust # Brid Buy or Sell Symbol Price Qty Commission 11/1/200500304 B56 SEL HAE 48.5 1000 35 11/1/200501888 B24 BUY HBP 8.5457 6000 240 Tell me how many records have symbols that being with the letter H.____17 You MUST show me your query and result grid. My answer Query1 TradeDate Custid Brid BuySell Symbol Price Qty Commission 11/1/200500304 B56 SEL HAE 48.5 1000 35 11/1/200501888 B24 BUY HBP 8.5457 6000 240 11/2/200501349 B80 SEL HD 41.2598 12271 613.55 11/1/200501844 B51 BUY HD 40.99 15000 450 11/1/200501873 B51 BUY HDI 48.9207 51900 1038 SELECT * From tbltrades where symbol like 'H*' order by symbol
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Query 2: How about all trades that were over 10,000 shares in order by Price from lowest to highest. Query 2
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

First%20Exam%20Make%20Up%20Questions - St. Johns University...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online