Snowflake + AI Session-2 | Data Querying | Select Operations | @vitechtalks | SQL

Hi Welcome to ViTech Talks , Here we are going to talk about Data Querying and aggregate functions Snowflake Training Class-2 ---------------------- Data Querying (Select) Logical operators AGGREGATE FUCNTIONS ----- MAX () MIN () AVG() SUM () COUNT() Class : -------- SELECT * FROM EMPLOYEES ; SELECT CURRENT_DATE() ; SELECT SYSDATE() ; SELECT CURRENT_TIMESTAMP() ; SELECT CURRENT_DATABASE() ; SELECT 5 + 5 ; SELECT 5 ; SELECT 'lAVANYA' || ' k' ; SELECT * FROM HR.TCS.EMPLOYEES ; USE HR.TCS ; SELECT * FROM EMPLOYEES ; SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID = 110 ; -- 1. Select all employees -- 2. Select specific columns -- 3. Filter by salary greater than a threshold 5000 -- 4. Sort employees by hire date (newest first) -- 5. Count employees per department -- 6. Find employees with no manager (top-le vel) -- 7. Get top 5 highest-paid employees -- 8. Search employees by name pattern start with J -- 9. Calculate average salary per department -- 10. Find employees hired in a specific year -- YEAR(hire_date) = 2024 -- 11. Find employees with salary between a range BETWEEN 40000 AND -- 12. Get distinct/unique department IDs -- 13. Count employees per manager -- 14. Find the minimum and maximum salary -- 15. Concatenate first and last name -- 16. Find employees hired in the last 90 days --hire_date = DATEADD(DAY, -- 17. Find departments with more than 5 employees -- 18. Select employees using IN clause for multiple departments -- 19. Calculate total salary expenditure per each department #cortexai #ai #SQL #vivisiontechnologies #snowflake #snowflaketraining #sqlzerotohero #database #snowflakeintegration #sqlroadmap #vivisiontech #sqltutorial #sqlforbeginners #snowflakes #SQL #vivisiontechnologies #snowflake #snowflaketraining #sqlzerotohero #database #sqltutorial #snowflakeonlinetraining #ADF #DBT #AZuredatafactory #Snowflake #WhatIsSnowflake #WhatIsSnowflakeDatawareHouse #SnowflakeTutorial #WhatIsSnowflakeDatabase #SnowflakeArchitecture