Find number of rows in output
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?
Answers ( No )
1. For Left Join, so according to the definition of the left join is that it will return all record form the left table & matched record from the Right table. The count of rows in Left Join is 2.
2. For Right join, so according to the definition of the right join is that it will return all record from the right table & matched record from the Left Table. The count of rows in Right Join is 5.
3. For inner join, so according to the definition it will return all the records that have matched in both the sides. The count of rows in Inner Join is also 2.
4. For Cross Join it creates all paired combinations of the rows of the table that will be joined i.e., M*N ( Considering that M & N are rows of the given tables ). The count of rows in Cross Join is 10.
5. For Full outer join, so according to the definition it will return the records when there is a match in either in Left or Right Table. So the count of rows in Full Outer Join is 5.
Inner join , Left Outer Join Right outer join, Full Outer join will have same result as:
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
Inner join , Left Outer Join Right outer join, Full Outer join will have same result as:
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
Inner join , Left Outer Join Right outer join, Full Outer join will have same result as:
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
Inner join , Left Outer Join Right outer join, Full Outer join will have same result as:
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
1,1
10 rows in all joins.
In all cases, 10 rows