I recently gave test on codility platform and was stuck on below SQL question. Question: For an online platform assessments were conducted for 3 topics and scores were provided. Table: Assessments Input: |Id|experience|sql|algo|bug_fixing| |1 |5 |100|null|100 | |2 |1 |100|100…
I want to calculate the percentage of the position of a football player field-wise to the country they belong to. Let's say, there are a total 800 players from Nepal whereas only 20 were goal keepers so percentage would be…
I am pulling data from 2 collections as shown in this MongoDB playground. While pulling the data from the second collection, I want to create a match on tag, such that only those posts are returned that have the particular…
I have one data example like this one in MongoDB. { id: 628a8683fc489c315b330ade, examName : 'Final Exam', schedule: { scheduleDate : '2021-10-18T17:00:00.000+00:00' scheduleName : 'Package Test' package:[ { exclude_question:[1,2], namePackage:testing packageId:628a89c2fc489c315b330b01 } ] }, question:[ { id:1, question:'hello can u…
I have my orders collection as [ { _id:'134', items:[ { _id:'itemId1' quantity: 2, price: 100,, couponsApplied:[] }, { _id:'itemId2' quantity: 2, price: 200,, couponsApplied:[] } ] } ] I want to apply 5% discount to each items above. i.e…
I work in the PHPMYADMIN environment. My goal was to download data from the Internet that describes judges, the regions in which they work, the files they made, the number of decisions, their salaries and similar things that I upload…
I have data that looks like this: country source 0 UK Ads 1 US Seo 2 US Seo 3 China Seo 4 US Seo 5 US Seo 6 China Seo 7 US Ads For each country I want to get…