The Operations Rejected by the System

Added on - 16 Sep 2019

  • Dissertation

    type

  • 7

    pages

  • 1034

    words

  • 173

    views

  • 0

    downloads

Showing pages 1 to 3 of 7 pages
STUDENT NAME:8 November 2016DATABASE ASSIGNMENT0|P a g e0
ContentsPART 1...................................................................................................................................................2PART 2...................................................................................................................................................3PART 3...................................................................................................................................................5PART 4...................................................................................................................................................5
PART 1a.SELECT * FROM CUSTOMER;b.SELECT CUSTI_ID, CUST_TITLE FROM CUSTOMER;c.SELECT * FROM LEAD WHERE AMOUNT > 12000;d.SELECT * FROM LEAD WHERE AMOUNT <= 12000 AND POSSIBILITY > 50;e.SELECT * FROM LEAD WHERE AMOUNT >= 12000 OR POSSIBILITY > 70;f.SELECT * FROM CUSTOMER WHERE CUST_PC IN (55120, 55124, 37300, 77501);g.SELECT * FROM CUSTOMER WHERE CUST_TITLE LIKE 'B%';h.SELECT * FROM CUSTOMER WHERE CUST_TITLE LIKE '%r';i.SELECT * FROM CUSTOMER WHERE CUST_PC LIKE '_5%';j.SELECT * FROM LEAD WHERE EXPECTED_DATE > '2015-06-01';k.UPDATE LEAD SET AMOUNT = (AMOUNT/2) + AMOUNT;SELECT * FROM LEAD WHERE AMOUNT > 25000 ORDER BY AMOUNT DESCl.SELECT CUST_TITLE, CUST_STATE, CUST_PC FROM CUSTOMER ORDER BY CUST_STATE,CUST_PC DESC;m.SELECT COUNT(*) FROM SLPRS;n.SELECT COUNT(SLPRS_TELEPHONE) FROM SLPRS;o.SELECT COUNT(DISTINCT(CUSTOMER_ID)) ASNO_OF_DIFFERENT_CUSTOMER_LEADS_BELONG FROM LEAD;p.SELECT COUNT(DISTINCT(CUSTOMER_ID)) ASNO_OF_DIFFERENT_CUSTOMER_LEADS_BELONG, COUNT(DISTINCT(SLPRS_ID)) ASNO_OF_DIFFERENT_SALESPERSON FROM LEAD;q.SELECT SUM(AMOUNT) FROM LEAD WHERE POSSIBILITY > 65;r.SELECT SUM(AMOUNT), AVG(AMOUNT), COUNT(LEAD_ID) FROM LEAD WHERE STATUS = 'I';
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document