Part 1 SQL Learning

-

SELECT * FROM yt_Opportunities_Data


SELECT New_Account_No, Opportunity_ID FROM yt_Opportunities_Data

SELECT * FROM yt_Opportunities_Data WHERE Product_Category = 'Services'

SELECT * FROM yt_Opportunities_Data WHERE Product_Category = 'Services' AND Opportunity_Stage = 'Stage - 4'

SELECT * FROM yt_Opportunities_Data WHERE Product_Category = 'Services' OR Opportunity_Stage = 'Stage - 4'

SELECT * FROM yt_Opportunities_Data WHERE Product_Category = 'Services' AND Opportunity_Stage IN ('Stage - 1','Stage - 3')

SELECT * FROM yt_Opportunities_Data WHERE Opportunity_Stage IN ('Stage - 1','Stage - 3')

SELECT * FROM yt_Opportunities_Data WHERE Opportunity_Stage NOT IN ('Stage - 1','Stage - 3')

SELECT * FROM yt_Opportunities_Data WHERE New_Opportunity_Name LIKE '%Phase - 1%'

SELECT * FROM yt_Opportunities_Data WHERE New_Opportunity_Name NOT LIKE '%Phase - 1%' AND Opportunity_Stage IN ('Stage - 1','Stage - 3')

SELECT * FROM yt_Opportunities_Data WHERE (Product_Category = 'Services' AND Opportunity_Stage = 'Stage - 4') OR New_Opportunity_Name LIKE '%Phase - 7%'

SELECT * FROM yt_Opportunities_Data WHERE Est_Opportunity_Value > '50000'

SELECT * FROM yt_Opportunities_Data WHERE Est_Opportunity_Value < '50000'

SELECT * FROM yt_Opportunities_Data WHERE Est_Opportunity_Value BETWEEN '30000' AND '50000' -- These value char type in table, so '30000' use

SELECT * FROM yt_Opportunities_Data
SELECT * FROM yt_account_lookup
SELECT * FROM yt_Calendar_lookup

SELECT * FROM yt_Opportunities_Data WHERE New_Account_No IN (SELECT New_Account_No FROM yt_account_lookup WHERE Sector = 'Banking')


SELECT * FROM yt_Opportunities_Data
SELECT * FROM yt_Calendar_lookup

SELECT * FROM yt_Opportunities_Data WHERE Est_Completion_Month_ID IN (SELECT DISTINCT Month_ID FROM yt_Calendar_lookup WHERE Fiscal_Year='FY20')

SELECT * FROM yt_Opportunities_Data WHERE Est_Completion_Month_ID IN (SELECT DISTINCT Month_ID FROM yt_Calendar_lookup WHERE Fiscal_Year='FY20') AND Est_Opportunity_Value > '50000' -- Here Est_Opportunity_Value is varchar

Comments

Post a Comment

Popular posts from this blog

Software Engineering MCQs

-
  What is the first step in the software development lifecycle? System Design Coding System Testing Preliminary Investigation and Analysis What does the study of an existing system refer to? Details of DFD Feasibility Study System Analysis System Planning Which of the following is involved in the system planning and designing phase of the Software Development Life Cycle (SDLC)? Sizing Parallel run Specification freeze All of the above What does RAD stand for? Rapid Application Document Rapid Application Development Relative Application Development None of the above       RAD   is categorized as an agile development method , which is meant to accomplish a quick turnaround and high-end outcomes. Which of the following prototypes does not associated with Prototyping Model? Domain Prototype Vertical Prototype Horizontal Prototype Diagonal Prototype The major drawback of RAD model is __________. It requires highly skilled developers/designers. It necessitat...
Read more