vsushko / research Goto Github PK

research projects

Java 20.11% Scala 0.03% Ruby 0.01% AspectJ 0.02% FreeMarker 0.03% HTML 27.11% JavaScript 14.48% TypeScript 26.09% CSS 11.66% PLSQL 0.08% Clojure 0.32% PigLatin 0.05% Pug 0.01%

research's Introduction

Hi there 👋

I am Vasiliy Sushko, a full-stack software engineer with 10+ years of experience in developing enterprise applications. Enjoy working in high-performing teams and creating projects from scratch using the whole stack of technologies from top to bottom.

If you'd like to get in touch with me, you can reach me at [email protected].

Languages and Tools

Latest Articles

Active Projects

Leetcode patterns aggregator

This repo is intended for any individual wanting to improve their problem-solving skills for software engineering interviews.

Problems are grouped under their respective subtopic, to focus on repeatedly applying common patterns rather than randomly tackling questions.

I'd love to receive contributions from the community and - you! See more for details here.

SchemesAnalyzer

SchemesAnalyzer is a free and open tool for analyzing XSD schema sets. This tool does not require the presence of the Internet, which is suitable for those users who work on the intranet.

Links

Docs
GitHub

This project is a free and open (under Apache 2 license) tool. I'd love to receive contributions from the comunity and - you! There are many ways to contribute, from writing wiki posts, improving the documentation, submitting bug reports and feature requests or writing code which can be incorporated into SchemesAnalyzer itself.

I'm teaching

OTUS is an online education platform. Data Engineer is a course where I am a teacher and give lectures.

Certifications

2024

2023

2022

2021

2020

2019

2018

2017

Connect with Me

research's People

Contributors

Watchers

research's Issues

explore 500 pages of Spring in Action

This would be ~5/7 part of book challenge.

create sql folder

ALTER SESSION SET CURRENT_SCHEMA = "SCOTT";
/*
-- chapter 3
SELECT SNUM, SNAME, CITY, COMM FROM SALESPEOPLE;
SELECT * FROM SALESPEOPLE;
SELECT SNUM, COMM FROM SALESPEOPLE;
SELECT ODATE, SNUM, ONUM, AMT FROM ORDERS;
SELECT SNUM FROM ORDERS;
SELECT DISTINCT SNUM FROM ORDERS;
SELECT SNAME, CITY FROM SALESPEOPLE WHERE CITY = 'London';
SELECT * FROM CUSTOMERS WHERE RATING = 100;
SELECT ONUM, AMT, ODATE FROM ORDERS;
SELECT * FROM CUSTOMERS WHERE SNUM = 1001;
SELECT CITY, SNAME, SNUM, COMM FROM SALESPEOPLE;
SELECT RATING FROM CUSTOMERS WHERE CITY = 'San Jose';
SELECT DISTINCT SNUM FROM ORDERS;

-- chapter 4
SELECT * FROM CUSTOMERS WHERE RATING >= 200;
SELECT * FROM CUSTOMERS WHERE CITY = 'San Jose' AND RATING > 200;
SELECT * FROM CUSTOMERS WHERE CITY = 'San Jose' OR RATING > 200;
SELECT * FROM CUSTOMERS WHERE CITY = 'San Jose' OR NOT RATING > 200;
SELECT * FROM CUSTOMERS WHERE NOT(CITY = 'San Jose' OR RATING > 200);
SELECT * FROM ORDERS WHERE NOT ((ODATE = '10.03.1990' AND SNUM > 1002) OR AMT > 2000.00);
SELECT * FROM ORDERS WHERE SNUM > 1000;
SELECT SNAME, CITY FROM SALESPEOPLE WHERE CITY = 'London' AND COMM > .10;
SELECT * FROM CUSTOMERS WHERE RATING <= 100 AND NOT (CITY = 'Rome');
SELECT * FROM ORDERS WHERE (AMT < 1000 OR NOT (ODATE = '10.03.1990' AND CNUM > 2003));
SELECT * FROM ORDERS WHERE NOT ((ODATE = '10.03.1990' OR SNUM > 1006) AND AMT >= 1500);

-- chapter 5
SELECT * FROM SALESPEOPLE WHERE CITY IN ('Barcelona', 'London');
SELECT * FROM CUSTOMERS WHERE SNUM IN (1001, 1007, 1004);
SELECT * FROM SALESPEOPLE WHERE COMM BETWEEN .10 AND .12;
SELECT * FROM SALESPEOPLE WHERE (COMM BETWEEN .10 AND .12) AND NOT COMM IN (.10, .12);
SELECT * FROM CUSTOMERS WHERE CNAME BETWEEN 'A' AND 'G';
SELECT * FROM CUSTOMERS WHERE CNAME LIKE 'G%';
SELECT * FROM SALESPEOPLE WHERE SNAME LIKE 'P L%';
SELECT * FROM SALESPEOPLE WHERE SNAME LIKE '%/_%'ESCAPE'/';
SELECT * FROM CUSTOMERS WHERE CITY IS NULL;
SELECT * FROM CUSTOMERS WHERE CITY IS NOT NULL;
SELECT * FROM CUSTOMERS WHERE NOT CITY IS NULL;
SELECT * FROM SALESPEOPLE WHERE CITY NOT IN ('London', 'San Jose');
SELECT * FROM ORDERS WHERE ODATE IN ('03.10.1990','04.10.1990');
SELECT * FROM SALESPEOPLE WHERE SNAME IN ('Peel', 'Motika');
SELECT * FROM SALESPEOPLE WHERE SNAME BETWEEN 'A' AND 'G';
SELECT * FROM SALESPEOPLE WHERE SNAME LIKE 'C%';
SELECT * FROM ORDERS WHERE AMT <> 0 AND (AMT IS NOT NULL);

-- chapter 6
SELECT SUM(AMT) FROM ORDERS;
SELECT AVG(AMT) FROM ORDERS;
SELECT COUNT(DISTINCT SNUM) FROM ORDERS;
SELECT COUNT () FROM CUSTOMERS;
SELECT COUNT (ALL RATING) FROM CUSTOMERS;
SELECT MAX(1 + (AMT)) FROM ORDERS;
SELECT SNUM, MAX(AMT) FROM ORDERS GROUP BY SNUM;
SELECT SNUM, ODATE, MAX(AMT) FROM ORDERS GROUP BY SNUM, ODATE;
SELECT SNUM, ODATE, MAX(AMT) FROM ORDERS GROUP BY SNUM, ODATE HAVING MAX(AMT) > 3000.00;
SELECT SNUM, MAX(AMT) FROM ORDERS WHERE ODATE = '10.03.1990' GROUP BY SNUM;
SELECT SNUM, MAX(AMT) FROM ORDERS GROUP BY SNUM HAVING SNUM IN (1002, 1007);
SELECT COUNT() FROM ORDERS WHERE ODATE = '10.03.1990';
SELECT COUNT(DISTINCT CITY) FROM CUSTOMERS;
SELECT CNUM, MIN(AMT) FROM ORDERS GROUP BY CNUM;
SELECT MIN(CNAME)FROM CUSTOMERS WHERE CNAME LIKE 'G%';
SELECT CITY, MAX(RATING) FROM CUSTOMERS GROUP BY CITY;
SELECT ODATE, COUNT (DISTINCT SNUM) FROM ORDERS GROUP BY ODATE;

-- chapter 7
SELECT SNUM, SNAME, CITY, COMM * 100 FROM SALESPEOPLE;
SELECT SNUM, SNAME, CITY, ' % ', COMM * 100 FROM SALESPEOPLE;
SELECT ' FOR '|| ODATE || ', THERE ARE ' || COUNT (DISTINCT ONUM) || ' ORDERS.' FROM ORDERS GROUP BY ODATE;
SELECT * FROM ORDERS ORDER BY CNUM DESC;
SELECT * FROM ORDERS ORDER BY CNUM DESC, AMT DESC;
SELECT SNUM, ODATE, MAX(AMT) FROM ORDERS GROUP BY SNUM, ODATE ORDER BY SNUM;
SELECT SNUM, COUNT (DISTINCT ONUM) FROM ORDERS GROUP BY SNUM ORDER BY 2 DESC;
SELECT ONUM, SNUM, AMT * .12 FROM ORDERS;
SELECT 'FOR THE CITY ' || CITY || ', THE HIGHEST RATING IS: ' || MAX(RATING) FROM CUSTOMERS GROUP BY CITY;
SELECT RATING, CNAME, CNUM FROM CUSTOMERS ORDER BY RATING DESC;
SELECT ODATE, SUM(AMT) FROM ORDERS GROUP BY ODATE ORDER BY 2 DESC;
*/

-- chapter 8
SELECT CUSTOMERS.CNAME, SALESPEOPLE.SNAME, SALESPEOPLE.CITY
FROM SALESPEOPLE, CUSTOMERS WHERE SALESPEOPLE.CITY = CUSTOMERS.CITY;