I'm wondering if any of you can assist with an interesing SQL
query. I have a single table within a database, the relevant fields of
which are defined as:
CREATE TABLE tableA
Where "domain" is a domain, such as:
An example of rows might be:
"mime" is defined as having entries such as:
What I am after doing with this table is writing an SQL query which
produces a count of all domains where the mime is equal to "text/html"
and next to that, a total count for that domain where the mime type is
"image/*" -- so for example, I might expect the returned resultset to
Domain domaincount Mimecountimages
---------------- ----- ----
google.com 120 12
emeraldcity. 200 40
teddybears.com 11 2
So far, we've considered and tried using a same-table join, various
group-by and rollup ideas, but am unable to come up with anything which
will produce the above in ONE row for each domain.
Any advice and assistance would be great!
A Custom Database Designed for Your Business