Question
You are assigned a new project which involves helping a food delivery company save more money. The problem is, company’s delivery team aren’t able to deliver food on time. As a result, their customers get unhappy. And, to keep them happy, ...
in progress 1
2 days 1 Answer 40 views Contributor

Question
You are working on a time series data set. You manager has asked you to build a high accuracy model. You start with the decision tree algorithm, since you know it works fairly well on all kinds of data. Later, you ...
in progress 0
2 days 1 Answer 25 views Contributor

Question
You are given a data set. The data set has missing values which spread along 1 standard deviation from the median. What percentage of data would remain unaffected? (Hint- Don’t forget to mention about the thought process that you put for ...
in progress 1
2 days 1 Answer 34 views Contributor

Question
You are given a train data set having 2000 rows and 1.2 Million columns. The data set is based on a classification problem. You are asked to reduce the dimension of this data so that model computation time can become ...
in progress 1
2 days 3 Answers 61 views Contributor

Question
SUBSCRIPTIONS user_id start_dt end_dt 1 01/01/18 31/03/18 2 01/02/18 30/04/18 3 01/01/18 31/01/18   CM first_dt last_dt 01/01/18 31/01/18 01/02/18 28/02/18 01/03/18 31/03/18 Find no. of subscribers each month or MoM. Output be like : Month             subcriber_count Jan’18              2 Feb’18             2 Mar’18            2 Apr’18             1
0
4 days 0 Answers 14 views Newbie

Question
You have data of people having applied for a lottery ticket. The data consists of their name and ticket number. You have to choose winners by selecting the people present in the alternate rows (first winner starting from row number ...
in progress 0
4 days 4 Answers 129 views Contributor

Question
Write a query for collecting the names of children who pursuing their graduation in their residential city. NAME AGE ADDRESS COLLEGE ……. …… ….. …..   (Hint- Look for the common city name in the columns of ADDRESS and COLLEGE)
in progress 1
4 days 2 Answers 55 views Contributor

Question
Sometimes you are not given a problem, but are asked to create one along with the solution. You will understand this concept through the next question. What is the function of OFFSET command? You might know the definition but create a ...
in progress 0
4 days 2 Answers 38 views Contributor

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August You are supposed to provide a salary raise to the employees who have joined after the 31 June. Collect the names of the employees who satisfy the condition.
in progress 1
4 days 3 Answers 44 views Contributor

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   Get the details of the employees whose "FirstName" does not start with any of the characters between 'c-r'
in progress 0
4 days 3 Answers 37 views Contributor

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   How will you get the data of the Nth highest salary from the table? Also, find the third highest salary by substituting values of N.
in progress 1
4 days 1 Answer 36 views Contributor

Question
NAME SALARY Date of Joining Angad 50,000 05 July Bhuvan 52,000 19 March Danish 77,000 06 September Manhar 64,000 15 May Shivraj 50,000 10 July Tanuj 55,000 13 August   Get all the employee detail from Employee Detail table whose "FirstName" starts with A and contain 5 letters.
in progress 0
4 days 2 Answers 26 views Contributor

Question
Write a suitable query where you will collect the names of visitors in a conference who have less than 8 characters in their name. Also, separate the ones with a middle name. (Hint- You can take appropriate column_names)
in progress 1
4 days 1 Answer 30 views Contributor

Question
How can you create an empty table from an existing table? Write the steps and explain the working. Take the following table for instance and create a new table named as cstudent. NAME MARKS ROLL NUMBER Ashutosh 87 1001 Bhavya 92 1002 Garima 69 1003 Pratham 75 1004 Sushant 90 1005
in progress 1
4 days 3 Answers 28 views Contributor

Question
Write an SQL Query find number of employees whose DOB is between 01/07/1965 to 31/12/1975. Collect the data separately for different gender. Use column name as sex, DOB table name Employees. (Hint- Imagine a hypothetical data)
in progress 1
4 days 2 Answers 34 views Contributor

Question
You are a part of a MNC and someone complains that their app is running slow because of what they think is a "database problem". How do you go about investigating the slowness and helping them to improve their queries? (Hint- You ...
0
4 days 0 Answers 6 views Contributor

Question
How to go about picking a good PARTITION key for a big table, and what are some of the "gotchas" of a badly chosen PARTITION key. It might seem to be simple, but you need to give a good explanation ...
0
4 days 0 Answers 6 views Contributor

Question
Name Gender X MALE XY FEMALE XYZ FEMALE Y MALE YZ FEMALE YZX MALE Z FEMALE The given table is a part of a larger table consisting data of people present in a meeting. This data needs to be sorted and the output should be like this, MALE FEMALE 3 4 Write the query accordingly.
0
4 days 0 Answers 6 views Contributor

Question
What is alternative for TOP clause in SQL? Anyone having knowledge of SQL is aware about TOP clause, but only a person with deep understanding can answer this question. (Hint-You might discuss various alternatives to get the same work done)
0
4 days 0 Answers 7 views Contributor

Question
Could you tell output or result of following SQL statements? (Hint- In some cases, there may be an error. So, try to locate them and answer accordingly) select 5 select ‘5’ select count (‘5’) select count (5) select count (*)
0
4 days 0 Answers 6 views Contributor

Question
empid empname managerid deptid Salary 1 Emp1 0 1 6000 2 Emp2 0 5 6000 3 Emp3 1 1 2000 13 Emp13 2 5 2000 11 Emp11 2 1 2000 9 Emp9 1 5 3000 8 Emp8 3 1 3500 7 Emp7 2 5 NULL 3 Emp3 1 1 2000 In the same table, some duplicate records might be present by mistake. Sort out a way to locate them and find a way to delete them.
0
4 days 0 Answers 6 views Contributor

Question
empid empname managerid deptid Salary 1 Emp1 0 1 6000 2 Emp2 0 5 6000 3 Emp3 1 1 2000 13 Emp13 2 5 2000 11 Emp11 2 1 2000 9 Emp9 1 5 3000 8 Emp8 3 1 3500 7 Emp7 2 5 NULL 3 Emp3 1 1 2000 Can you get the list of employees with the same salary? You just need to focus on a particular section of the table. (Hint- Try to be specific)
0
4 days 0 Answers 6 views Contributor

Question
empid empname managerid deptid Salary 1 Emp1 0 1 6000 2 Emp2 0 5 6000 3 Emp3 1 1 2000 13 Emp13 2 5 2000 11 Emp11 2 1 2000 9 Emp9 1 5 3000 8 Emp8 3 1 3500 7 Emp7 2 5 NULL 3 Emp3 1 1 2000 Can you get employee details whose department id is not valid or department id not present in the department table?
0
4 days 0 Answers 7 views Contributor

Question
Refer to the following table and answer the questions related to it. empid empname managerid deptid Salary 1 Emp1 0 1 6000 2 Emp2 0 5 6000 3 Emp3 1 1 2000 13 Emp13 2 5 2000 11 Emp11 2 1 2000 9 Emp9 1 5 3000 8 Emp8 3 1 3500 7 Emp7 2 5 NULL 3 Emp3 1 1 2000   The Employee and manager id are in the same table. Is it possible to get the manager names for the corresponding employee? How will you proceed for the same?
in progress 0
4 days 1 Answer 9 views Contributor

Question
The following table consists of some data in the 7 rows 10/12 1a/90 23/11 2442 22/3c 11/43 dd/ss You can clearly see that the table is not uniform. In reality, this table should consist the data in the form of NN/NN. Verify that the first and last two characters ...
0
4 days 0 Answers 7 views Contributor