Scenario: You have a business request to provide a list of service companies that have more than 1,000 unique sites and

[answerhappygod]

Scenario You Have A Business Request To Provide A List Of Service Companies That Have More Than 1 000 Unique Sites And 1 (108.39 KiB) Viewed 27 times

Scenario: You have a business request to provide a list of service companies that have more than 1,000 unique sites and 10 unique jobs associated to it. Using the table relationship diagram provided, write a query that will return these EXACT results, as presented (site_ct & job_ct may be different, but nothing else about the results should change): SERVCO NAME SITETYPE_ID SITE_CT JOB CT 1 RANGER AMERICAN WB HOLDINGS IN A 3762 40 2 ADT Security А 3387 62 3 DEFENDERS INC A 3267 1241 4 COUNTERFORCE A 3260 35 5 RANGER AMERICAN WB HOLDINGS, I A 2286 30 6 SAFE STREETS USA LLC A 2171 1856 7 SEYAH LTD A 1145 19 BASIC TABLE RELATIONSHIPS: CONTRACT CONT NO NUMBER CONTSTAT_ID VARCHAR STATUS EFFECTIVE DATE DATE CUST_NO NUMBER CUSTOMER_SITE CUST NO NUMBER SITE NO NUMBER START_DATE DATE END DATE DATE CUSTOMER CUST NO NUMBER CUST_NAME VARCHAR CUST_ADDR1 VARCHAR CITY NAME VARCHAR STATE_ID VARCHAR ZIP CODE VARCHAR SITE SITE_NO SITE NAME SITE_ADDR CITY_NAME STATE ID ZIP CODE SITETYPE_ID SERVCO_NO NUMBER VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR NUMBER P RECUR LINE CONT NO NUMBER RECLINE NO NUMBER BILLTO CUST_NO NUMBER SERVICE SITE NO INUMBER RECBSTAT_ID VARCHAR MONTHLY AMT NUMBER RECUR_START_DATE DATE RECUR END DATE DATE BILLCODE ID VARCHAR JOB JOB NO JOBSTAT_ID SITE NO CREATE DATE COMPLETE DATE NUMBER VARCHAR NUMBER HUST BALANCE FORWARD HIST CUST_NO NUMBER START_BAL AMT NUMBER END_BAL AMT NUMBER END_BAL_DATE DATE SERVICE COMPANY SERVCO_NO NUMBER SERVCO NAME VARCHAR DATE DATE BILL CODE BILLCODE ID VARCHAR DESCR VARCHAR SERVTYPE_ID VARCHAR