Diademata

Implement the missing code, denoted by ellipses. You may not modify the pre-existing code.The application you've been working on for the past year is a huge success! It already has a large and active user community. You know the ID number, username, and email of each user. Each user also has a specific role that shows their position in the community. Information about the users is stored in the ..

You've been promoted and assigned to a new project. The problem is, you don't know who you are working with and your predecessor has vanished without a trace! Luckily, each project in your company keeps its own activity database, which you are going to use to find out the names of your new colleagues. Information about the project's activity is stored in table projectLog, which has the following..

Students at your university get scholarships that are paid out throughout the year. Information about the scholarships is stored in the table scholarships, which has the structure: id: the unique student id;scholarship: the amount of the annual scholarship the student has been awarded.Now you need to calculate the amount of money each student should get per month. Given the table scholarships, b..

Your friend wants to become a professional tour guide and travel all around the world. In pursuit of this dream, she enrolled in tour guide school. The professors in this school turned out to be very demanding, and one of them gave your friend a difficult assignment that she has to finish over the weekend. Here's the assignment: Given a list of countries, your friend should identify all the coun..

월급 밀려서 퇴사하고 2주 정도 놀았는데.. 최근에 작은 회사에 취업해서 다시 공부하기 위해서 codefights를 들어갔는데 쿼리도 풀 수 있게 해놨네? ㅋㅋ Your boss wants to identify the successful projects running in your company, so he asked you to prepare a list of all the currently active projects and their average monthly income. You have stored the information about these projects in a simple database with a single Projects table that has five columns: ..