SELECT sum(p.PointValue) as [Total Points],
d.FirstName + ' ' + d.lastname as [Driver],
d.kartnumber as [Kart Number],
rc.RaceClass as [Race Class]
FROM driver_tbl d
JOIN Results r on d.driverid = r.DriverID
JOIN Points_tbl p on r.PointID = p.PointID
JOIN RaceSchedule_tbl rs on  r.RaceScheduleID = rs.RaceScheduleId
JOIN RaceClassLookup_tbl rc on r.RaceClassID = rc.RaceClassID
WHERE rs.RaceComplete = 1
GROUP BY d.KartNumber, d.FirstName, d.LastName, rc.RaceClass

namespace Shaffer.Models.ViewModel
 {
public class DriversModel
{
    public int DriverID { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string NickName { get; set; }
    public string KartNumber { get; set; }
    public int RaceClassID { get; set; }
    public bool checkedin { get; set; }
}
}

namespace Shaffer.Models.ViewModel
{
  public class PointsModel
    {
    [Key]
    public int PointID { get; set; }
    public string Result { get; set; }
    public string ResultDesc { get; set; }
    public int PointValue { get; set; }
    }
}

namespace Shaffer.Models.ViewModel
  {
   public class RaceClassModel
    {
    public int RaceClassID { get; set; }
    public string RaceClass { get; set; }
    }
}

namespace Shaffer.Models.ViewModel
 {
  public class RaceScheduleModel
   {
    public int RaceScheduleID { get; set; }
    public string RaceName { get; set; }
    public DateTime RaceDate { get; set; }
    public bool RaceComplete { get; set; }
    }
}