Bonjour la communaute,

voila pour etre franc, une boite me demande de repondre a cette question quelques soient les moyens utilises, je dois repondre correctement meme si la reponse ne vient pas de moi.

Merci d'avance pour votre temps.

-----------------------------------------

Skill Assessment Sheet

Line
Contains


50
char *b, q, *r;

200
b = getbuf ();

201
q = *b;

212
R = anotherfunction (b);

213-2003
/* we want to use 'q' and 'r' here */

2000
char * getbuf ()

2001
{

2002
char buff [8];

2003-2050
/* unspecified buff defined here */

2051
return (char*) buff;

2052
}


Question: There is a table with gene_ids ('gid') and clone_ids ('cid'). Each gene only resides on a single clone and each clone may contain multiple genes. How do would you find how many genes are on each and every clone? Please provide the SQL.