StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
20046334
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-18T11:11:23.477
FavoriteCount
0
LastActivityDate
2016-01-07T19:33:06.463
LastEditDate
2016-01-07T19:33:06.463
LastEditorUserId
13302
OwnerUserId
1948325
ParentId
20046146
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Let's suppose your table has columns called <code>Title</code>, <code>path</code> and <code>request_date</code>, then, your query could be:</p> <pre><code> select Title, path, (select count(*) from page_views as pv2 where month(request_date)=2 and pv1.Title = pv.Title and pv2.path = pv.path ) as January, (select count(*) from page_views as pv1 where month(request_date)=2 and pv1.Title = pv.Title and pv2.path = pv.path ) as February, (select count(*) from page_views as pv3 where month(request_date)=3 and pv1.Title = pv.Title and pv2.path = pv.path ) as April, (select count(*) from page_views as pv5 where month(request_date)=5 and pv1.Title = pv.Title and pv2.path = pv.path ) as May, (select count(*) from page_views as pv6 where month(request_date)=6 and pv1.Title = pv.Title and pv2.path = pv.path ) as June, (select count(*) from page_views as pv7 where month(request_date)=7 and pv1.Title = pv.Title and pv2.path = pv.path ) as July, (select count(*) from page_views as pv1 where month(request_date)=1 and pv1.Title = pv.Title and pv2.path = pv.path ) as January, (select count(*) from page_views as pv8 where month(request_date)=8 and pv1.Title = pv.Title and pv2.path = pv.path ) as August, (select count(*) from page_views as pv9 where month(request_date)=9 and pv1.Title = pv.Title and pv2.path = pv.path ) as September, (select count(*) from page_views as pv10 where month(request_date)=10 and pv1.Title = pv.Title and pv2.path = pv.path ) as October, (select count(*) from page_views as pv11 where month(request_date)=11 and pv1.Title = pv.Title and pv2.path = pv.path ) as November, (select count(*) from page_views as pv12 where month(request_date)=12 and pv1.Title = pv.Title and pv2.path = pv.path ) as December from (select distinct Title,path from page_views ) as pv </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POReturn a count from a given month as column
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USmarc_s
UserOwnerUserId
1. USOscar Pérez
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.