Board index   FAQ   Search  
Register  Login
Board index PHP PHP General

MY SQL AND PHP :help:

General discussions related to php

Moderators: macek, egami, gesf

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:
gianeukin
New php-forum User
New php-forum User
 
Posts: 2
Joined: Mon Jun 23, 2014 2:14 pm

Re: MY SQL AND PHP :help:

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

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


Return to PHP General

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron