SQL Qs Database Design – Python required

SQL https://sqliteonline.com/

Part 1 – Qs SQL
1. Explore Clinical and Genomics Tables
2. Find all patients that are alive and have a ‘AKT1’ or ‘TP53’ mutation
3. Count the number of patients with each type of cancer
4. Find the age distribution for patients with stage 3 or higher
5. What is the most prevelent genomic mutation?
6. What is the longest average survival in months and years?
7. Write a query that would find and delete duplicate IDs assuming they exist.
8. Write a query transaction that will change stage to III for patients who are alive, have Adenocarcinoma and a tumor size greater than 2.

Part 2 – Qs Database Design
1. Look at VCF files, design a table that can be added to the current genomic and clinical tables.
2. What is the key, what columns would the table have, what type of columns?
3. What language would you use to write this code & why?
4. Describe the pseudo code for this script.

https://repl.it/languages

Language of your choice

Part 3 – Qs Language specific
1. Write a function that determines if a string starts with an upper-case letter A-Z
2. Write a function that determines the area of a circle given the radius
3. Add up all the values in an array
4. Sort an array with strings alphabetically
5. Write a function that determines if a value is even or uneven
6. Calculate the mean of an array.

Last Completed Projects