Question 1: SQL
----------------
Assume you have the following tables:
Item
+-------------+--------------+------+-----+----------------+
| Field | Type | Null | Key | Extra |
+-------------+--------------+------+-----+----------------+
| itemID | int(11) | | PRI | auto_increment |
| name | varchar(64) | | | |
| description | varchar(128) | YES | | |
| categoryID | int(11) | YES | | |
+-------------+--------------+------+-----+----------------+
Category
+-------------+--------------+------+-----+----------------+
| Field | Type | Null | Key | Extra |
+-------------+--------------+------+-----+----------------+
| categoryID | int(11) | | PRI | auto_increment |
| name | varchar(64) | | | |
+-------------+--------------+------+-----+----------------+
ItemOrderMembership
+-------------+--------------+------+-----+----------------+
| Field | Type | Null | Key | Extra |
+-------------+--------------+------+-----+----------------+
| orderID | int(11) | | | |
| itemID | int(11) | | | |
+-------------+--------------+------+-----+----------------+
Write a query that will get me the item name and item category name for
all items in orderID 12345. Please note that [login to view URL] may be NULL,
and that the query should return item names even for those records where
this is the case.
Question 2: Python Programming
-----------------------
A teacher gives a class of students an exam. He decides to grade the
exam using the following method:
* A score in the top 20% of all scores is an A.
* A score in the next 20% of scores is a B.
* A score in the next 20% of scores is a C.
* A score in the next 20% of scores is a D.
* A score in the bottom 20% of scores is an F.
For example, if a class of 20 students has the following scores:
99, 92, 91, 91, 89, 85, 83, 82, 80, 79, 78, 78, 77, 76, 75, 74, 62, 55, 43, 20
The first four scores (99, 92, 91, 91) would be an A, scores 5 through 8 (89,
85, 83, 82) would be a B, scores 9 through 12 (80, 79, 78, 78) would be a C,
scores 13 through 16 would be a D (77, 76, 75, 74) and scores 17 through 20
(62, 55, 43, 20) would be an F.
Write a function that takes an arbitrary (possibly unsorted) score list of any
length (not necessarily the list used as an example above) as a parameter, and
returns a grade for each score.
Note that since the list of scores can be of any length the number of scores
may not necessarily be divisible by 5. Please make sure your function will
handle those cases gracefully and consistently.
ADDITIONAL REQUIREMENT: If there are two (or more) scores that are identical,
then those identical numerical scores must always receive the same grade, even
if that causes some grades to contain more scores than others.
You may use any programming language you wish. Please make sure your code is
syntactically valid and would produce an output that identifies which letter
grade is received by each numerical score in the input list.
Hi there, I went through the requirements and I would like to do this project if given the opportunity. I'm a SQL developer and I can definitely get this done. Let me know if you are interested. Thanks.
Hello
I am Python and SQL expert and interested in this project. I have reviewed the attached both questions and confident to handle it perfectly.
I have a lot of experience in helping in students with assignments, so I will keep codes well documented and simple.
Please communicate to discuss further.
Regards
Anshu
I am very proficient in java. I have 16 years java developing experience now, and have worked for more than 6 years. My work is online game developing, and mainly focus on server side, using java under linux environment. I used java to make many great projects, for example, I made the tools which can convert java files into c++ scripts, of course garbage collection included, this job is very similar to a compiler, and is very complex. I also made our own mobile game using java, I can show you the demo of client, if you like. I have a very good review on Freelancer.com, I never miss a project once I accept the job, you can check my review. Trust me, please let expert help you. Besides, I am very proficient in c++ also, hope I can help you.
We are team of excellent developers. We have 2 year experience related to your project field. We can do your project and solve your all problems according to your requirements. We have read your description for projects and we understand what you want so we are confident that we can do it easily in mention time. We assure you that you will be completely satisfy with our work. And after delivering your project if you feel some issue in understanding the projects then we will teach you free until you understand.
If you have any question then feel free to ask. We are here for you.
Thank you
Hey I am good in both python and mysql and have very good development experience in them. Please visit my profile for more information on my skills. If you like it and want me to do this work please inbox me. Thanks :) . P.S : We can also negotiate on bid.
Hi,
Hope you are doing well. I have worked on Metlife Compensation app and have 3 years of experience in JAVA, SQL, SPRING & HIBERNATE.
I can submit the answer within 20 mins.
Let me know if you find me the right candidate for this.