SQL query-table help urgent

DROP TABLE IF EXISTS table1;

CREATE TABLE table1
(pid INT NOT NULL AUTO_INCREMENT PRIMARY KEY
,productdesc VARCHAR(30) NOT NULL UNIQUE
,productcode VARCHAR(20) NOT NULL UNIQUE
);

DROP TABLE IF EXISTS table2;

CREATE TABLE table2
(date DATE NOT NULL 
,pid INT NOT NULL 
,PRIMARY KEY(date,pid)
);

INSERT INTO table1 VALUES
(1,'Packet-Eye','P001'),
(2,'Wiggy','W099'),
(3,'Wimax-Lite','W001'),
(4,'Wimax-Home','W002');

INSERT INTO table2 VALUES
('2009-01-01',1),
('2009-01-12',1),
('2009-02-14',2),
('2009-03-03',3);

SELECT t1.productdesc `Product Description`,t2.date `Registration Date` FROM table1 t1 JOIN table2 t2 ON t2.pid = t1.pid;
+---------------------+-------------------+
| Product Description | Registration Date |
+---------------------+-------------------+
| Packet-Eye          | 2009-01-01        |
| Packet-Eye          | 2009-01-12        |
| Wiggy               | 2009-02-14        |
| Wimax-Lite          | 2009-03-03        |
+---------------------+-------------------+

SELECT t1.something Product
     , DATE_FORMAT(t2.something_else,'%Y-%m') dt
     , COUNT(*) total 
  FROM table2 t2 
  JOIN table1 t1 
    ON t1.another_thing = t2.another_thing 
GROUP 
    BY t1.another_thing
     , dt;