by 
STOP THE PRESSES! Native Applications dropped into public preview this morning, meaning we’ve been busy giving you a challenge to sink your teeth into!
Use the below code for your ‘data’ database.
Start Up Code
CREATE DATABASE IF NOT EXISTS FROSTY_APP;
CREATE SCHEMA IF NOT EXISTS FROSTY_APP.CORE;
CREATE OR REPLACE TABLE FROSTY_APP.CORE.FIREY_FRIDAY (ID INT, CHALLENGE VARCHAR, TOPIC VARCHAR);
INSERT INTO FROSTY_APP.CORE.FIREY_FRIDAY (ID, CHALLENGE, TOPIC) VALUES
(1, ‘Challenge 1’, ‘Arrays’),
(2, ‘Challenge 2’, ‘Sorting Algorithms’),
(3, ‘Challenge 3’, ‘Linked Lists’),
(4, ‘Challenge 4’, ‘Stacks and Queues’),
(5, ‘Challenge 5’, ‘Arrays’),
(6, ‘Challenge 6’, ‘Graphs’),
(7, ‘Challenge 7’, ‘Recursion’),
(8, ‘Challenge 8’, ‘Dynamic Programming’),
(9, ‘Challenge 9’, ‘Arrays’),
(10, ‘Challenge 10’, ‘Bit Manipulation’),
(11, ‘Challenge 11’, ‘String Manipulation’),
(12, ‘Challenge 12’, ‘Graphs’),
(13, ‘Challenge 13’, ‘Greedy Algorithms’),
(14, ‘Challenge 14’, ‘Object-Oriented Programming’),
(15, ‘Challenge 15’, ‘Arrays’),
(16, ‘Challenge 16’, ‘Concurrency and Multithreading’),
(17, ‘Challenge 17’, ‘Error Handling and Debugging’),
(18, ‘Challenge 18’, ‘Design Patterns’),
(19, ‘Challenge 19’, ‘Arrays’),
(20, ‘Challenge 20’, ‘SQL Queries’),
(21, ‘Challenge 21’, ‘RESTful APIs’),
(22, ‘Challenge 22’, ‘Dynamic Programming’),
(23, ‘Challenge 23’, ‘Containerization and Virtualization’),
(24, ‘Challenge 24’, ‘CI/CD’),
(25, ‘Challenge 25’, ‘Automated Testing’),
(26, ‘Challenge 26’, ‘Web Security’),
(27, ‘Challenge 27’, ‘Arrays’),
(28, ‘Challenge 28’, ‘Networking Basics’),
(29, ‘Challenge 29’, ‘Cloud Computing’),
(30, ‘Challenge 30’, ‘Arrays’),
(31, ‘Challenge 31’, ‘RESTful APIs’),
(32, ‘Challenge 32’, ‘SQL Queries’),
(33, ‘Challenge 33’, ‘Sorting Algorithms’),
(34, ‘Challenge 34’, ‘Bit Manipulation’),
(35, ‘Challenge 35’, ‘Graphs’),
(36, ‘Challenge 36’, ‘Object-Oriented Programming’),
(37, ‘Challenge 37’, ‘String Manipulation’),
(38, ‘Challenge 38’, ‘Concurrency and Multithreading’),
(39, ‘Challenge 39’, ‘Design Patterns’),
(40, ‘Challenge 40’, ‘Error Handling and Debugging’),
(41, ‘Challenge 41’, ‘CI/CD’),
(42, ‘Challenge 42’, ‘Automated Testing’),
(43, ‘Challenge 43’, ‘Web Security’),
(44, ‘Challenge 44’, ‘Arrays’),
(45, ‘Challenge 45’, ‘Networking Basics’),
(46, ‘Challenge 46’, ‘Cloud Computing’),
(47, ‘Challenge 47’, ‘Containerization and Virtualization’),
(48, ‘Challenge 48’, ‘RESTful APIs’),
(49, ‘Challenge 49’, ‘Dynamic Programming’),
(50, ‘Challenge 50’, ‘SQL Queries’);
At Frosty Friday, we’re awfully competitive and hate that Firey Friday exists. They’re all about coding challenges of any kind/variety. But ew! Stole our idea much???
This app is all about spying on them, we want each of our developers to have an app that can let them track Firey Friday and keep them in check. The app should be a stored procedure that will let us track what they’re doing and all their phoney challenges.
Create an app that will spy on them!
We want a stored procedure called CALL SPY_ON_FIREY_FRIDAY.CORE.TOP_3_TOPICS(); that will produce the following output:
As of writing, you can access the documentation via the Apps section:
Remember, if you want to participate:
- Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
- Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
- Post the URL in the comments of the challenge
Leave a Reply
You must be logged in to post a comment.