PLEASE ANSWER THE QUESTIONS USING STANDARD SQL:

What is the most common price? [Please write a SQL query that will output just one column and one row] ***Please use subqueries***

Example:

price

0.0

HERE IS MY SQL QUERY WHICH IS NOT AS EFFICIENT:

SELECT COUNT(*) AS favorite

FROM fake_apps

GROUP BY Price

HAVING COUNT(*) = (

SELECT max(favorite)

FROM (

SELECT COUNT(*) AS favorite

FROM fake_apps

GROUP BY Price)

fake_apps

);

What category of apps are priced at the most common price?

id	name	category	downloads	price
3	siliconphase	Productivity	17193	0.0
6	Donzolab	Education	4259	0.99
10	Ittechi	Reference	3874	0.0
13	Subdrill	Education	7132	1.99
14	Anzoom	Health & Fitness	6941	14.99
21	kanity	Health & Fitness	2299	0.0
25	Zathcare	Books	16281	2.99
30	Basecode	Sports	21203	3.99
45	Hayholding	Medical	15845	14.99
59	Sailflex	Productivity	21984	0.99
60	waretam	Catalogs	31087	2.99
62	Donelectrics	News	6650	1.99
81	sonelectrics	Entertainment	9297	1.99
89	Zoodom	Food & Drink	29619	14.99
94	Quohouse	Lifestyle	4109	0.0
95	Quotetech	Health & Fitness	24934	0.0
104	Funtexon	Utilities	11229	0.99
108	Ozerphase	Navigation	14881	0.0
109	Kintonflex	Catalogs	28705	0.0
110	Tamptom	Education	5918	2.99
122	Whitetexon	Games	30959	0.0
123	Lanela	Business	21116	1.99
126	Ozerquote	Lifestyle	19422	3.99
128	Unosantech	Finance	15659	0.99
130	Canplus	Lifestyle	22923	1.99
132	Mathzoom	Books	30862	1.99