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 0
4 months 35 Answers 747 views 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
4 months 34 Answers 631 views Member

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
4 months 21 Answers 421 views Member

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
3 months 16 Answers 882 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
3 months 13 Answers 1061 views Great Grand Master

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
3 months 12 Answers 389 views Great Grand Master

Question
Suppose in class, you have 3n boys and 2n girls with their names tabulated along with their weight and gender. Write a SQL query to separate students alphabetically who are over-weight (55kg for girls, 75kg for boys)
in progress 0
3 months 9 Answers 265 views Great Grand Master