select.sql

there are some sql interogations that i have made for my paper work

SELECT Model ,Viteza, HD FROM pc_uri WHERE Pret<500;
SELECT DISTINCT Producator FROM Produse WHERE Tip='imprimante';
SELECT Model,Ram,Ecran FROM laptop_uri WHERE Pret>1000;
SELECT *FROM imprimante WHERE color='da';
SELECT Model,Viteza,HD FROM pc_uri WHERE Pret<600 AND (cd='12x' OR cd='24x');
SELECT Producator,Viteza FROM Produse,laptop_uri WHERE (produse.Model=laptop_uri.Model) AND (hd>=10);
SELECT Model,Pret FROM laptop_uri
WHERE Model IN (SELECT Model FROM produse WHERE producator='B')
UNION
SELECT Model,Pret FROM Pc_uri
WHERE Model IN (SELECT Model FROM produse WHERE producator='B')
UNION
SELECT Model,Pret FROM imprimante
WHERE Model IN (SELECT Model FROM produse WHERE producator='B');

SELECT Producator FROM produse
WHERE Model IN (SELECT Model pc_uri) AND (Model NOT IN (SELECT Model FROM
laptop_uri));
SELECT Producator FROM Produse WHERE Model IN (SELECT Model FROM pc_uri WHERE Viteza!<450);
SELECT Model,Pret FROM imprimante WHERE Pret=(Select MAX(Pret)from imprimante);
SELECT AVG(Viteza) AS Viteza_medie FROM pc_uri;
SELECT AVG(Viteza) AS Viteza_medie FROM laptop_uri WHERE Pret>1000;
SELECT AVG (Viteza) AS Viteza_medie FROM pc_uri,produse WHERE (pc_uri.Model=produse.Model) AND (Producator='A');
SELECT Viteza,AVG(Pret) AS Pret_mediu FROM pc_uri GROUP BY Viteza;

SELECT  Hd=P1.Hd FROM pc_uri AS P1, pc_uri AS P2 WHERE P1.Hd=P2.Hd AND P1.Cod=P2.Cod ;

SELECT distinct r1.Model AS ModelCuNumarMare,r2.Model AS ModelCuNumarMic,r1.Viteza AS
Viteza,r1.Ram AS Ram FROM pc_uri AS r1,pc_uri AS r2
WHERE  r1.Model !=r2.Model AND r1.Viteza=r2.Viteza AND r1.Ram=r2.Ram ;
SELECT produse.Tip,laptop_uri.Model,laptop_uri.Viteza FROM produse,laptop_uri
WHERE laptop_uri.Viteza<(SELECT MIN(Viteza) FROM pc_uri) AND
laptop_uri.Model=produse.Model;

SELECT DISTINCT Producator,Pret FROM produse,imprimante
WHERE Color='Da' AND Pret=(SELECT MIN(Pret) FROM imprimante WHERE Color='Da')
AND produse.Model=imprimante.Model;

SELECT Producator, AVG(Ecran) AS Ecran FROM produse,laptop_uri
WHERE laptop_uri.Model=produse.Model GROUP BY Producator;
SELECT Producator,COUNT(pc_uri.Model) AS Nr_modele FROM produse,pc_uri
WHERE produse.Model=pc_uri.Model GROUP BY Producator HAVING COUNT
(pc_uri.Model)>=3;
SELECT Producator,MAX(Pret) AS Pret_Maxim FROM produse,pc_uri
WHERE produse.Model=pc_uri.Model GROUP BY Producator;

SELECT Viteza,AVG(Pret) AS Pret_mediu FROM pc_uri
WHERE Viteza>600 GROUP BY Viteza;

SELECT DISTINCT Producator FROM produse
WHERE Producator IN(SELECT Producator FROM produse,pc_uri WHERE
produse.Model=pc_uri.Model AND pc_uri.Viteza!<750) AND Producator IN (SELECT
Producator FROM produse,laptop_uri WHERE produse.Model=laptop_uri.Model AND
laptop_uri.Viteza!<750);

SELECT Model FROM (SELECT Model,Pret FROM pc_uri UNION SELECT Model,Pret FROM
laptop_uri UNION SELECT Model,Pret FROM imprimante) AS rf
WHERE Pret=(SELECT MAX(un.Pret) FROM (SELECT Pret FROM pc_uri UNION SELECT
Pret FROM laptop_uri UNION SELECT Pret FROM imprimante) AS un);

SELECT DISTINCT Producator FROM (SELECT Producator FROM produse,imprimante
WHERE imprimante.Model=produse.Model) AS pp
WHERE Producator IN (SELECT Producator FROM produse,pc_uri WHERE
pc_uri.Model=produse.Model AND Ram IN (SELECT MIN(Ram) FROM pc_uri));

SELECT AVG(Pret) AS Pret_mediu_comun FROM (SELECT Pret FROM produse,pc_uri
WHERE pc_uri.Model=produse.Model AND Producator='A' UNION SELECT Pret FROM
produse,laptop_uri WHERE laptop_uri.Model=produse.Model AND Producator='A')
AS r1;
SELECT Producator, AVG(Pret) AS Pret_med_prod FROM Produse,pc_uri WHERE
Producator IN (SELECT Producator FROM produse, imprimante WHERE
produse.Model=pc_uri.Model) GROUP BY Producator;
SELECT AVG(Hd) AS Capac_med_Hd FROM Produse, pc_uri WHERE Producator IN
(SELECT Producator FROM produse, imprimante WHERE
produse.Model=imprimante.Model) AND produse.Model=pc_uri.Model;