Question
I have a table student with only one column i.e. Roll No. The values in the table are 10 20 10 10 20 There are in total 3 repetitive values i.e. 10 is repeated two extra times and 20 is repeated one ...
solved 6
4 months 62 Answers 1230 views Grand Master

Question
We have two columns(Revenue and Cost Price) in a table like below, get me the Profit column Revenue       Cost Price        Profit 100                  Null            ...
solved 5
1 year 43 Answers 2216 views Grand Master

Question
The mean of a distribution is 20 and the standard deviation is 5. What is the value of the coefficient of variation?
in progress 1
1 year 43 Answers 1902 views Contributor

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 1
1 year 21 Answers 3304 views Great Grand Master

Question
We have the following values 10000 10000 20000 30000 30000 30000 What would be the result of row number, rank, and dense rank ?
solved 1
1 year 21 Answers 1145 views Contributor

Question
Name Designation Joining_Date Salary Ashutosh Singla HR 2019-12-15 80,000 Chandan Garg Admin 2019-10-09 60,000 Himanshi Kaur HR 2019-03-13 75,000 Mohit Dharm HR 2019-05-27 85,000 Meena Batra Accountant 2019-07-11 50,000 Omkar Singh Accountant 2019-01-05 45,000 Pratham Garg Admin 2019-05-27 65,000 Rakesh Sharma HR 2018-06-30 75,000 Sharadha Gupta Accountant 2019-09-18 50,000 Demonstrate how to write a query to show details of an HR whose name starts with M.
in progress 0
1 year 17 Answers 1266 views Great Grand Master

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) Example Nitin 26 Patna Patna Ankit 27 Bangalore Pune Result - Nitin
in progress 2
1 year 13 Answers 3517 views Great Grand Master

Question
All you have to do is to go through the code and comment the question for which the following is an answer of SELECT matchid, player FROM goal WHERE teamid = 'GER'
in progress 2
1 year 11 Answers 672 views Grand Master