Temat: Programowanie - temat ogólny

Select categoryname, productname, MAX(maxx) as NajlepiejSprzedajacy from
	(select ProductID, sum(productid) as maxx from dbo.OrderDetails od group by productid) od inner join dbo.Products p on od.productid=p.ProductID
		inner join dbo.Categories as C on p.CategoryID=c.CategoryID
	group by CategoryName,od.maxx,ProductName

#include <stdio.h>
#include <time.h>
#include <stdlib.h>
#include <math.h>
int main()
{
	FILE *dane1, *dane2, *wynik;
	dane1=fopen("dane1.txt","r"); 
    if(dane1==NULL) {return 1;}
	dane1=fopen("dane2.txt","r"); 
    if(dane2==NULL) {return 1;}
	wynik=fopen("wynik.txt","w"); 
    if(wynik==NULL) {return 1;}
	int l1,l2,x;
	for(x=0;x=100;x=x+1)
	{
		if(feof(dane1)!=0) 
                           {break;}
		fscanf(dane1,"%d",&l1);
		fscanf(dane2,"%d",&l2);
		
        if(l2%2==0) 
                    {fprintf(wynik,"l1 %d\n",l1);}
	}
	fclose(dane1);
	fclose(dane2);
	fclose(wynik);
	system ("pause");
	return 0;
	
}