SQL statements
-
Can anyone help me write the answers to this question in sql, I couldn't manage to upload, a full question, can anyone help with a simple demonstration on this question based on any assumption I) Find the Employers name, address of employers and the number of students sponsored by each employee. iv) Find the average fees of students sponsored by employer with number 02
-
Can anyone help me write the answers to this question in sql, I couldn't manage to upload, a full question, can anyone help with a simple demonstration on this question based on any assumption I) Find the Employers name, address of employers and the number of students sponsored by each employee. iv) Find the average fees of students sponsored by employer with number 02
I guess no one could help you without seeing the database structure and the exact problem you have to do it yourself.
-
Can anyone help me write the answers to this question in sql, I couldn't manage to upload, a full question, can anyone help with a simple demonstration on this question based on any assumption I) Find the Employers name, address of employers and the number of students sponsored by each employee. iv) Find the average fees of students sponsored by employer with number 02
As Victor said, there is no way anyone can help without knowing what the table structure is. Where are you stuck?
-
Can anyone help me write the answers to this question in sql, I couldn't manage to upload, a full question, can anyone help with a simple demonstration on this question based on any assumption I) Find the Employers name, address of employers and the number of students sponsored by each employee. iv) Find the average fees of students sponsored by employer with number 02
Have you read point #11 here?
"One man's wage rise is another man's price increase." - Harold Wilson
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons
"You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles
-
Can anyone help me write the answers to this question in sql, I couldn't manage to upload, a full question, can anyone help with a simple demonstration on this question based on any assumption I) Find the Employers name, address of employers and the number of students sponsored by each employee. iv) Find the average fees of students sponsored by employer with number 02
You need to: select from employers join to students group by count Then join that query to fees group by avg Seriously if this is beyond you then withdraw from the course.
Never underestimate the power of human stupidity - RAH I'm old. I know stuff - JSOP