CLOSE ALL

CALCULATE average(medias1 + medias2)/2 FOR LEFT(clasa, 2) = "09" TO x
CALCULATE average(medias1 + medias2)/2 FOR LEFT(clasa, 2) = "10" TO y
CALCULATE average(medias1 + medias2)/2 FOR LEFT(clasa, 2) = "11" TO z
CALCULATE average(medias1 + medias2)/2 FOR LEFT(clasa, 2) = "12" TO w

SCAN FOR LEFT(clasa, 2) = "12"
CALCULATE MAX((medias1 + medias2) / 2) TO a
ENDSCAN
SCAN FOR LEFT(clasa ,2) = "12" AND (medias1 + medias2) = a
?nume
ENDSCAN

CALCULATE average(x + y + z + w) TO m
?m

CALCULATE MAX(absn) TO r
SCAN FOR(absn = r)
?nume
?clasa
ENDSCAN

SCAN FOR((medias1 + medias2)/2 < 5) AND absn >= 40
e = e + 1
ENDSCAN

LIST FOR(caminist = T)
SCAN FOR(caminist = T)
CALCULATE average(medias1 + medias2)/2 TO p
ENDSCAN
?p