MY SQL AND PHP :help:

General discussions related to php

Moderators: macek, egami, gesf

gianeukin
New php-forum User
New php-forum User
Posts: 2
Joined: Mon Jun 23, 2014 2:14 pm

MY SQL AND PHP :help:

Postby gianeukin » Mon Jun 23, 2014 2:20 pm

Consider that has beeb created one MySQL database called "grades" and has four (4) fields: name (name) and last name of a student (surname), the grade (grade) and semester (semester) with indicative prices Records shown below.
A. To write a php file that prints the maximum, minimum and average score of all students each semester.
B. To write a php file that prints the name (name) and last name of students who are below the average score of all students regardless of the semester
C. To write a php file that prints the name (name) and last name of students per semester who have rated at least one unit below the maximum score of students in the same semester

Name Surname grade semester
Nikos Panos 9 3
Babis Tsiknas 8 3
Andray Panos 5 5
Andray Alexiou 2 5

Can you help me plz What is the sollution ? :help:

User avatar
Strider64
New php-forum User
New php-forum User
Posts: 84
Joined: Sat Mar 23, 2013 8:24 am

Re: MY SQL AND PHP :help:

Postby Strider64 » Tue Jun 24, 2014 6:43 am



Return to “PHP General”

Who is online

Users browsing this forum: No registered users and 1 guest