What will be the output of Following SQL Query
Question
Related questions
The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?
Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?
Write a Query to Find the account with the highest number of followers in every country. Explain the approach?
Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?
Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?
Answer ( 1 )
After Running the code will return the columns name, last_name, and salary from the table Salary, but only where the salary is greater than the average number of salary from Salary Table.
The inner query executes first.
Therefore it will first compute average of salary among the salaries in the salary table and then select the salaries that are greater than the value of avg(salary).
Then these selected tuples will return to the above query where their name,last_name and salary will be printed for the people whose salaries is greater than avg(salary) which is returned by inner query.
It will return only those salaries which are greater than the average salary .