Ask a question from expert

Ask now

The Operations Rejected by the System

7 Pages1034 Words382 Views
   

Added on  2019-09-16

The Operations Rejected by the System

   Added on 2019-09-16

BookmarkShareRelated Documents
STUDENT NAME: 8 November 2016DATABASE ASSIGNMENT0 | P a g e0
The Operations Rejected by the System_1
ContentsPART 1...................................................................................................................................................2PART 2...................................................................................................................................................3PART 3...................................................................................................................................................5PART 4...................................................................................................................................................5
The Operations Rejected by the System_2
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)) AS NO_OF_DIFFERENT_CUSTOMER_LEADS_BELONG FROM LEAD;p.SELECT COUNT(DISTINCT(CUSTOMER_ID)) AS NO_OF_DIFFERENT_CUSTOMER_LEADS_BELONG, COUNT(DISTINCT(SLPRS_ID)) AS NO_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';
The Operations Rejected by the System_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
BANKING SCENARIO PROCEDURES Faisal Jahdlai 08 December, 2016 BANKING SCENARIO PROCEDURES Faisal Jahdali 08 December, 2016 ER DIAGRAM 2 CREATE AND INSERT TABLE COMMANDS 2 SQL PROCEDURES Faisal Jahdlai
|19
|1901
|149

Database Fundamentals: ER Diagram, SQL Queries, Importance of ER Diagram, Legal Issues and Security Techniques
|20
|2283
|323

Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies
|7
|800
|134

Database Design and SQL
|9
|1255
|102

Banking Scenario Procedure Database SQL
|9
|1874
|471

Banking Assignment - Procedures Database SQL
|20
|1754
|421