Part IV$.-$ M:M Recursive

In Part IV$,$ you will practice querying the patent database on the MySQL server. You will need to use the

citation and patents tables.

$(1$pts$)$ Find out which patents are citing patent No$.3992014.$

$(2$pts$)$ Find out which patents are citing patent No$.3992014.$ List the category and applied year

of the citing patents.

$(2$pts$)$ Find out which patents are citing patent No$.3992014.$ List the category and applied year

of both cited and citing patents.

Table: citation

Columns:

patentNo varchar$(25)$ PK

citinqPNo varchar$(25)$ PK

Table: patents

Columns:

patentNo

varchar$(25)$ PK

yearofgrant

int$(11)$

yearofapply

int$(11)$

state

varchar$(5)$

category

varchar$(12)$