/* Step 1 */ SELECT COUNT(Id) AS num_posts FROM posts; S...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

/* Step 1 */
SELECT COUNT(Id)
AS num_posts
FROM posts;

SELECT MIN(CreationDate)
AS min_date
FROM posts;

SELECT MAX(CreationDate)
AS max_date
FROM posts;

Select AVG(Score)
AS avg_num_posts
FROM posts;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results