My brain is fried right now on inner joins. I need an sql query to achieve the output results in the image below:
at the end of your query would be this statement:
and url_domain = 'a.com'
using postgres as the db (shouldn't matter for the query if you are a mysql guru)
first to get the query correct wins a t3report of your choosing (up to a 3 credit report which is a $1200 value).
this is also a mini-interview as I have need for some sql/perl ppl
Fight the contest!