No products in the cart.

a) Write a Query to display …

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

a) Write a Query to display the City and the number of stores located in that City, only if number of stores is more than two. b) Write output SELECT COUNT(STOREID), NOOFEMP FROM STORE GROUP BY NOOFEMP HAVING MAX(SALESAMT)<60000; c) Write a query to display names of stores along with Sales Amount of those stores that are located in Mumbai.

Posted by Prachi Singh 3 years, 10 months ago

CBSE > Class 12 > Informatics Practices

0 answers

ANSWER

Related Questions

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Honey Hanisha 2 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

0 answers

Write a python program to plot aa bar chart showing the no. Of books published in respective year using the following data

Posted by Maanyata Sharma 3 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Write a program that generates the table of a input number using for loop

Posted by Siya Vishwakarma 1 week, 4 days ago

CBSE > Class 12 > Informatics Practices

0 answers

Create a dataframe using two series named a series_a and series_b with indexed as a to e and b to f respectively having data types of values as int , dropping NAN places in the dataframe

Posted by Chanchal R 3 months, 1 week ago

CBSE > Class 12 > Informatics Practices

1 answers

What is pandas

Posted by Mayur Singh 6 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

Question no 31 case 2024

Posted by Abdulla S 4 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Consider a given series,M1 write a program in python pandas to create the series

Posted by Martina Sangchoju 2 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

Founder of python

Posted by Parth Chaudhary 2 months ago

CBSE > Class 12 > Informatics Practices

2 answers

DBMS

Posted by Vishal Patel 6 months, 3 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Honey Hanisha 2 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices