SQL

Question 1

The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

0

SQL Anonymous 2 years 0 Answers 415 views

Question 2

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?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

in progress 0

SQL Anonymous 2 years 0 Answers 360 views

Question 3

Write a Query to Find the account with the highest number of followers in every country. Explain the approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

in progress 0

SQL Anonymous 2 years 0 Answers 427 views

Question 4

Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: Click Here)

0

SQL Anonymous 2 years 0 Answers 400 views

Question 5

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?

Question

SQL Case Study: Social Media Features: Country: Country Rank: Rank Account: Account Title: Title Link: Instagram Page Category: Category Authentic Engagement: Authentic Engagement Engagement Avg: Engagement Avg Scrapped Date: Scrapped Date Data Set: Excel File (Link: https://drive.google.com/file/d/12_SVXe7VO-53DJ14IJZilLfpiNWTbUUW/view?usp=sharing)

in progress 0

SQL Anonymous 2 years 0 Answers 466 views

Question 6

Suppose there is a theatre and you need to write a sql program where your code can provide options to a customer in a particular row if the person wants adjacent seat with x number of people

Question

There is one table with three columns i.e. column name, seat number and occupied(binary) Write a program for the above mentioned condition

0

SQL 2 years 0 Answers 684 views Grand Master

Question 7

Longest Streak in SQL

Question

Table - Incidents Column Date_of_incidence , incidents Get the start date with the longest period without any incidence

2

SQL 3 years 0 Answers 951 views Grand Master

Question 8

Getting the order of screen names

Question

Q: We have a product. It’s screen and event data is as below: Screen Name Event Name Timestamp A 1 ...

1

SQL 3 years 0 Answers 456 views Newbie

Question 9

Transposing Rows data into Columnar form

Question

Q: We have CUSTOMER table having columns as Customer_Name, Merchant_name (Amazon, Flipkart, Myntra etc.) and Transaction_value (Purchase value for each of these merchants). Write a query to Transpose this into Customer Name, Merchant Names as individual columns and their transaction ...

in progress 0

SQL 3 years 0 Answers 458 views Newbie

Question 10

Adding the missing months for customers

Question

Q: We have a CUSTOMER table having columns as Cust_ID, Month, Sales_value. Write a SQL query to add the missing months for each customer and to have sales value = 0, corresponding to those missing months which are added

in progress 2

SQL 3 years 0 Answers 433 views Newbie

Register Now

Login

Lost Password

Login

Register Now

SQL

Top Categories

Category : SQL

Subscribe to our newsletter