Find Jobs
Hire Freelancers

Calculate columns value in sql server query

$3-8 USD

Terminado
Publicado hace más de 12 años

$3-8 USD

Pagado a la entrega
it is an add-on task to calculate totalpracticalavg, totalpracticalpct, totaltheorypct, moduletotalresult with the sql query below: some of the lines have been made up from statement rather than coding task could be done remotely, prefer session start at 9:30pm kuala lumpur time select *, totalattendancepct = (CASE WHEN totalattendance <> 0 then astatusontime * 10 / totalattendance ELSE 0 END), totalpracticalavg = (fpractical1 + fpractical2 + fpractical3 + fpractical4 + fpractical5) / COUNT(IS NOT NULL(5 practicals) ), totalpracticalpct = (totalpracticalavg * 60 ) / 100, totaltheorypct = IS NOT NULL (ftheory * 30) / 100 , moduletotalresult = totalattendancepct + totalpracticalpct + totaltheorypct from ( Select [login to view URL] as fpractical1, [login to view URL] as fpractical2,[login to view URL] as fpractical3, [login to view URL] as fpractical4, [login to view URL] as fpractical5, [login to view URL] as ftheory1, [login to view URL] as evaluation1, [login to view URL] as evaluation2, [login to view URL] as fpaper, [login to view URL] as modulefinalresult, [login to view URL] as modulename, [login to view URL] as moduleid, [login to view URL] as duration, [login to view URL] as briefdesc, [login to view URL] as pimage, [login to view URL] as studentname, (select COUNT(attendancestatus) FROM StudentAttendance sa INNER JOIN TraineeModule tm ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND sa.attendancestatus='ontime' AND [login to view URL] = [login to view URL]) as astatusontime, (select COUNT(attendancestatus) FROM StudentAttendance sa INNER JOIN TraineeModule tm ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND (sa.attendancestatus='late' OR [login to view URL] ='absense') AND [login to view URL] = [login to view URL]) as astatuslateabsense, (select COUNT(attendancestatus) FROM StudentAttendance sa INNER JOIN TraineeModule tm ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 AND [login to view URL] = [login to view URL]) as totalattendance from StudentResult sr INNER JOIN Module m ON [login to view URL] = [login to view URL] INNER JOIN Student s ON [login to view URL] = [login to view URL] INNER JOIN UserTable ut ON [login to view URL] = [login to view URL] WHERE [login to view URL] = 1 ) TAB1
ID del proyecto: 3412007

Información sobre el proyecto

1 propuesta
Proyecto remoto
Activo hace 13 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$5 USD en 1 día
4,8 (13 comentarios)
3,8
3,8

Sobre este cliente

Bandera de MALAYSIA
Malaysia
5,0
65
Forma de pago verificada
Miembro desde ago 30, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.