Hacker rank my sql. hacker_id, name from ( Select j.

Hacker rank my sql Proctoring allows the recruiter to monitor your test screen activity and identify potential malpractice. Also, when the output returned by your code is not the exact expected output format, you will see a "Wrong answer" status. Each solution includes a brief explanation of the problem and my approach to solving it. Structured Query Language is one of the most important languages used in the industry. Working through Weather Observation Station 6 on hackerRank, and I can't understand why the former code works but the latter does not. is_evil = 0 AND a. Don't panic! This is a SockJS hidden iframe. Field From table1 t" instead of "select t. power FROM wands a JOIN wands_property b ON a. ” I used the MySQL option on the platform to solve each of the challenges. submission_date < SUB1. Rules. hacker_id. Reply reply Top 1% Rank by size . group by h. Star 0. - GitHub - adarsh2104/journey-to-hackerank-SQL-gold-badge: This repository contains the solutions that I have submitted to earn SQL Gold Badge on the Hacker MySQL; Problem. Disclaimer: The HackerRank supports Microsoft SQL, MySQL, Oracle, and DB2 databases. Use subqueries instead: Select h. You may add any prizes that you would like to offer here. nums % b. Prizes. We define an employee’s total earnings to be their monthly salary x months worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. - atanugerah/hacker-rank-sql Mar 12, 2024 · The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. hacker_id group by hacker_id, h. coins_needed = (SELECT Min(a1. X AND F2. tables ; 125 | Query the names of students scoring higher than 75 Marks. My solution: WITH MaxScores AS ( SELECT Hacker_ID, Challenge_ID, MAX(Score) AS MaxScore FROM Submissions GROUP BY Hacker_ID, Challenge_ID ), SummedScores AS ( SELECT Hacker_ID, SUM(MaxScore) AS TotalScore FROM MaxScores GROUP BY Hacker_ID ) SELECT S. Share with friends: Sign Up. 5 hours long? Because Im solving ALL of the SQL Problems on Hackerrank in this video. Hacker 84072 submitted solutions for challenges 49593 and 63132, so the total score = 100 + 0 = 100. g. Doesn't my like clause detect a first letter starting with a vowel and then any wildcards following it? Just as the regexp anchors at the beginning of the string and checks that the first character is a vowel. marks FROM students S JOIN grades G ON S. Saved searches Use saved searches to filter your results more quickly Julia conducted a days of learning SQL contest. Please check 1. Problem. Motivation for Upgrade. someone please explain me why this is not correct select N, case when p is null then 'Root' when n not in (select distinct p from bst) then 'Leaf' else 'Inner' end as NodeType from bst order by n; i wrote it with a different logic as it wont find n in p column so it should assign it as leaf but i dont know how its still assigning 1,3 as inner Contains solved queries for the Hackerrank SQL (Basic) Skills Certification Test 🎓. hacker_id GROUP BY c. github mysql sql certificate hackerrank certification collaborate hackerrank-solutions hackerrank-sql hackerrank-sql-solutions gitlens hackerrank-certification student-vscode github-campus-experts hackerrank MySQL select distinct city from station where not (city like 'A%' or city like 'E%' or city like 'I%' or city like 'O%' or city like 'U%') or not (city like '%a' or city like '%e' or city like '%i' or city like '%o' or city like '%u'); Disclaimer: The above HackerRank concepts & solutions. nums)) AND a. Solve Challenge. Basic SQL Queries. MySQL SELECT CASE WHEN G. For Developers Join over million Generate the contest leaderboard. MySQL Server; Problem. name as name, COUNT(c. You signed out in another tab or window. To promote optimal coding practices in HackerRank Tests and online interviews, our coding environment has preset time and memory limits for code execution in each programming language. Sort the output by the LAST three characters of each name. It is guaranteed that the difference between Hacker 90411 got a score of 30 for challenge 71055 with a difficulty level of 2, so 90411 earned a full score for this challenge. The start date of the contest was March 01, 2016 and the end date was March 15, 2016. coins_needed, a. hacker_id group by h. Prithviraj Biswas. 0? We had been running AWS Relational Database Service (RDS) with extended support for MySQL 5. hacker_id = c. Participation in discussions helps a student understand diverse views and other Hackerrank's mysql version is old; too old to support CTEs. Example Task: Write a query that uses ROW_NUMBER to assign row numbers within partitions of a result set. Challenges: The challenge_id is the id of the challenge, and hacker_id is the id of the student who created the challenge. hacker_id as id, h. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. 1. It's used for cross domain magic. Creating a Database Question Click on the Library tab on the home page and then click on the Create Question button. hacker_id = SUB2. Reason: Window functions provide powerful tools for performing calculations across rows related to the current row. name. Why did we need to upgrade to MySQL 8. GROUP BY and ORDER BY algorithms to ensure proper output structure and sorting. Verify your SQL Skills. There are almost always multiple solutions to the Jan 10, 2025 · Hello coders, in this post you will get all the solution of HackerRank SQL Solutions. There is also a limit on how much rating you can gain or lose in single event which depends on the Contains solved queries for the Hackerrank SQL (Basic) Skills Certification Test 🎓. ') FROM OCCUPATIONS GROUP BY Occupation ORDER BY COUNT (*), Occupation. And I've absolutely bombed one or two of those. The interviewer mentioned I will be tested on SQL and Statistics, now when I clicked on the test link to see the test overview there are 3 sections. The available database languages are: You can select your preferred language at These concepts cover the fundamental syntax and basic features of SQL. submission_date AND (SELECT COUNT(DISTINCT submission_date) FROM Submissions AS SUB3 WHERE (SUB3. PHP stands for Hypertext Preprocessor, and is integrated with a number of popular databases, including MySQL, PostgreSQL, Oracle, Sybase, Informix, and Microsoft SQL Server. r/learnprogramming. There could be a couple reasons for this: Your code doesn't match the expected output. Domains Aug 8, 2022 · My submissions/answers for a set of SQL query quizzes to help prepare for interview questions regarding SQL ranging from Basic SQL to Advanced SQL. Write a query to print the hacker_id, name, and the total number of challenges created by each student. After some discussion, we finally decided to pick MySQL Upgrade to 8 as one of the items. sql sql-server hackerrank sql-query sqlserver hackerrank-solutions hackerrank-sql hackerrank-sql-solutions hacker-rank hackerrank-sql-challenge. Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. hacker_id) as cnt FROM hackers h INNER JOIN challenges c ON h. Problem: You are given a table, Projects, containing three columns: Task_ID, Start_Date and End_Date. 2. They are necessary for writing simple SQL queries and understanding the core structure and flow of database This repository is a collection of updated solutions to SQL challenges on HackerRank. The HackerRank Skills This repository contains my SQL solutions to HackerRank challenges, organized by difficulty: Easy, Medium, and Hard. Accelerate your Job Search. Please provide a short description of your contest here! This will also be used as metadata. These are not the only solutions. from hackers h. order by c_max desc limit 1) or c_count in (select distinct c_compare as c_unique. having c_count = (select count (c2. Sample Input 0. Reason: Basic queries are essential for retrieving data from a database. Hackers: The hacker_id is the id of the hacker, and name is the name of the hacker. The output Challenge Walkthrough Let's walk through this sample challenge and explore the features of the code editor. r/SQL. group by c2. Reload to refresh your session. X > F1. Medium SQL (Intermediate) Max Score: 30 Success Rate: 96. and find the hacker_id and name of the hacker who made maximum number of submissions each day. Domains. The problem involves HackerRank for Work generates detailed candidate test reports to help you evaluate a candidate’s performance in a test. Solve HackerRank problems to get Gold star and 670 points in SQL HackerRank. Members Online. In turn, these forums become vibrant centers for people to interact, obtain explanations, and discuss different ways of resolving issues. Data Integrity and Constraints  · Solutions to HackerRank practice, tutorials and interview preparation problems with Python 3, mySQL, JavaScript . Here are the most Julia asked her students to create some coding challenges. #hackerrank#sql#skills#certification. TotalScore My SQL Server. My code for this challenge is in MySQL: SELECT c. In the Select Question Query the details of the city with ID 1661. com/challenges/revising-the-select-query/problemProblem Statement - Current projects at work require more SQL skills, so I took the time to brush up my SQL knowledge using the HackerRank coding challenges platform. Disclaimer: The above Problem (Occupations) is generated by Hacker Rank but the Solution is Provided by CodingBroz. . Start hiring at the pace of innovation! Solutions for all SQL challenges on HackerRank executed on MySQL and MS SQL Server. This repository contains MySQL solutions of the HackerRank-SQL-Intermediate-Certificate problems which I encountered during the test. Note that the query provided by the op is not the final answer to This repository contains solutions for Hacker Rank SQL problems. Domains HackerRank's MySQL challenges allow one to improve their SQL skills through many different tasks. name having challenges_created = ( select count SELECT submission_date, ( SELECT COUNT(DISTINCT hacker_id) FROM Submissions AS SUB2 WHERE SUB2. join challenges c on c. 0 | Permalink. This key competency includes a basic understanding of the PHP environment, predefined PHP arrays containing variables, understanding and ability to write code to perform conditional operations, SQL Project Planning. Futher queries will per written on this view CREATE VIEW hacker_challenge_count AS select h. submission_date)) = oracle: with t1 as ( select level lvl from dual connect by level <= 20 order by level desc ) select rpad('* ', lvl*2, '* ') from t1; Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. This repository contains MySQL solutions of the Hackerrank SQL Intermediate questions - 007aneesh/Hackerrank-SQL-Intermediate-Solutions Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. 03%. 1 day ago + 2 comments. Field From table1 AS t" Query an alphabetically ordered list of CITY names not starting with vowels. Change your DBMS to “MySQL”. Basic Select Challenges. About. select case when a+b > c and b+c > a and a+c > b then case when a=b and b=c and a=c then 'equilateral' when a=b or b=c or a=c then 'isosceles' when a<>b and b<>c and a<>c then 'scalene' end else 'not a triangle' end as type_of_triangle from triangles; Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. marks BETWEEN G. You have an off-day, or some of the questions focus on things that Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. This is the only video you will need to improve you MySQL: HackerRank. Contest Leaderboard. challenge_id) j INNER JOIN Difficulty d Overview. challenge_id) as c_count. The crucial way through which harnessing the power of discussion forums can be maximized and the process of learning in MySQL challenge from hacker rank. Customer Spending. Hi all! So I've been given the HackerRank Data Analyst test for interview, for preparation I've been doing SQL practice on HackerRank. code = b. Could you please tell, Hacker 74842 submitted solutions for challenges 19797 and 63132, so the total score = max(98, 5) + 76 = 174. Average Population of Each Continent. from challenges as c2. ; Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. And the amount of change will depend on lot of factors including but not limited to performance of other users, the number of competitions you have participated in. select case when a+b > c and b+c > a and a+c > b then case when a=b and b=c and a=c then 'equilateral' when a=b or b=c or a=c then 'isosceles' when a<>b and b<>c and a<>c then 'scalene' end else 'not a triangle' end as type_of_triangle from triangles; You signed in with another tab or window. MySQL, PostgreSQL, and SQL Server have some of the best documentation for any system I've worked with. There's little reason to find alternatives. SQL-Product-Sales-per-City files for the Top Competitors. Okay, so my first crack at it? Let's just say it was more of a practice run. Get silver and gold rank with 600+ points. Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. hassanbazaf1. Hacker_ID, H. WITH hacker_rnk AS ( SELECT submission_date, hacker_id, ROW_NUMBER() OVER (PARTITION BY hacker_id ORDER BY submission_date) AS rnk FROM ( SELECT DISTINCT submission_date, hacker_id FROM Submissions ) AS i ), date_number AS ( SELECT ROW_NUMBER() OVER (ORDER BY submission_date) AS number, Print prime numbers. HackerRank is the market-leading coding test and interview solution for hiring developers. nums = 0); The logic presented in the In this post, I’ll share my solutions to some SQL problems on HackerRank, categorized as “Easy. grade DESC, SELECT DISTINCT city FROM station WHERE city REGEXP '^[aeiouAEIOU]. Sep 19, 2024 · That said, I will go through problems 1–5 using MySQL in this first part and work through the rest in subsequent posts. The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions. nums <= FLOOR (SQRT (a. 7, as it had reached its end of life. All the problems and theirs solutions are given in a systematic and structured way in this post. Wanting to learn SQL upvotes Solution – Print Prime Numbers in SQL | Hacker Rank Solution. max_mark ORDER BY G. 40%. BUSINESSFor Companies We are the market–leading technical interview platform to identify and hire developers with the right skills. So, without wasting any time, let’s Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. min_mark AND G. This repository contains MySQL solutions of the HackerRank SQL Intermediate Certificate problems which I encountered during the test. Take the HackerRank Certification Test and showcase your knowledge as a HackerRank verified developer. - adminazhar/hackerrank-SQL-basic-skills-certification-test-solution Improving the solution from Malkard, here is my simple solution for MySQL: set @ number = 21 ; select repeat ( '* ' , @ number : = @ number - 1 ) from information_schema . SQL-Business-Expansion and 2. PL/SQL is an extension of SQL language that combines the data manipulation power of SQL with the processing power of procedural language to create super-powerful SQL queries. select h. HackerRank, SQL, Alternative Queries, DRAW THE TRIANGLE 1, MySQL, MS SQL, DB2, Hive, APDaga, DumpBox, Akshay Daga, Set, limit, in SQL, Hacker, Rank Causes: Possible Resolution(s) Mismatch of input and output values : Test cases fail when the input passed by your code may not be in the exact format as expected by the test case. challenge_id = ch. Write a query to print total number of unique hackers who made at least submission each day HackerRank is a widely-used platform for practicing coding problems, preparing for technical interviews, and improving algorithmic skills. coins_needed) FROM wands a1 JOIN You signed in with another tab or window. Number Challenges Solutions; 1: Revising the Select Query I: SQL: 2: Revising the Select Query II: SQL: 3: Select All: SQL: 4: Select By ID: Pivot the Occupation column so the Name of each person in OCCUPATIONS is displayed underneath their respective Occupation. It’s one of the most sought languages desired by the employers as the volume of To view, all my achievements follow the link to my Hacker-Rank profile. hacker_id = c. This Repository Contains My Hacker Rank Solutions. name ELSE NULL end AS names, G. How to write SELECT queries to fetch relevant data in PostgreSQL and MySQL. Write a query to print all prime numbers less than or equal to 1000. Each solution is accompanied by comments for clarity, showcasing Mar 12, 2024 · The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. Nov 28, 2019 · MySQL to . Login Don’t have an account? Contact sales or Get free trial. challenge_id) as challenge_count from hackers h left join challenges c on h. - qanhnn12/SQL-Hackerrank-Challenge-Solutions Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. You switched accounts on another tab or window. name order by challenge_count desc, Problem Statement - 1https://www. name, count(c. X) AND (X != Y) UNION SELECT X, Y FROM FUNCTIONS F1 WHERE X Challenge Walkthrough Let's walk through this sample challenge and explore the features of the code editor. X = F1. I am solving question on Hackerrank and RDBMS is mysql This is code WITH cte AS ( SELECT salary, months * salary AS totals FROM employee ) SELECT DENSE_RANK() OVER (ORDER BY totals) AS rk F Hey there, fellow Data Folks and SQL Ninjas! Today, I want to share a simple solution to a challenging Hackerrank problem using MySQL. mysql leetcode-sql This time, a Hacker Rank certificate for SQL (Basic). If more than one such hacker has a maximum number of However, I have an interesting observation which is that if you switch from MySQL to MySQL server, then the CTE works, as indicated by the screenshot. WITH RECURSIVE t AS (SELECT 2 AS nums UNION SELECT nums + 1 FROM t WHERE nums < 1000) SELECT GROUP_CONCAT (nums SEPARATOR '&') FROM t WHERE nums NOT IN (SELECT a. hacker_id) as challenges_created from hackers h join challenges c on h. Leetcode and Hackerrank MySQL solution. hacker_id, COUNT(DISTINCT j. hacker_id, h. 15 days of Learning SQL. challenge_id) as c_max. Starts in. I have used MySQL and MS SQL Server for the solutions. Jan 10, 2025 · Top Competitors – HackerRank Solution; Ollivander’s Inventory – HackerRank Solution; Challenges – HackerRank Solution; Contest Leaderboard – HackerRank Solution; SQL Project Planning – HackerRank Solution; Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. It was a long due. hacker_id = h. Y AND F2. working platform:- mysql */ select h. Example Task: Install a relational database (e. You signed in with another tab or window. sql and 2. Activities involved: Writing SELECT statements, filtering results with WHERE clauses. challenge_id) as cnt from ( Select s. name, count (h. Without Further ado let’s dive straight in. - adminazhar/hackerrank-SQL-basic-skills-certification-test-solution MySQL solution , but first explanation of algorithm. These reports are available after the candidate submits And I've have technical interviews where they want me to solve certain tests/scenarios to test out my SQL skills. Suspicious transactions are defined as: a series of two or more transactions occur at intervals of an hour or less they are from the same sender the sum of transactions in a sequence is MySQL Solution: SELECT CONCAT (Name, "(", LEFT (Occupation, 1), ")") FROM OCCUPATIONS ORDER BY Name; SELECT CONCAT (' There are a total of ', COUNT (*), ' ', LOWER (Occupation), ' s. Ollivander's Inventory. submission_date = SUB1. age, a. 75%. id, b. Medium SQL (Intermediate) Max Score: 30 Success Rate: 92. Hacker 90411 got a score of 100 for challenge 66730 with a difficulty level of 6, so 90411 MySQL SELECT a. Sort your results by the total Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. hacker_id, h. More posts you may like r/SQL. Revising Activities involved: Using window functions like ROW_NUMBER, RANK, DENSE_RANK, LEAD, LAG. hackerrank. score as _score, difficulty_level, s. Business Expansion. - adminazhar/hackerrank-SQL-basic-skills-certification-test-solution Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. A subreddit for all questions related to programming in any language. MySQL SELECT name FROM students WHERE marks > 75 ORDER BY SUBSTR(name, LENGTH(name)-2, 3), id; Disclaimer: The above Problem (Higher Than 75 Marks) is generated by Hacker Rank but the Solution is -- creating a view for hacker id, name and no of challenges. Thrilled to share that I've just earned the Gold Badge in SQL on HackerRank! It's been an exhilarating journey of refreshing my knowledge, tackling challenging cases, and expanding my SQL toolkit Contains solved queries for the Hackerrank SQL (Basic) Skills Certification Test 🎓. The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. Contribute to BlakeBrown/HackerRank-Solutions development by creating an account on GitHub. Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. This tutorial is only for Educational and Learning Purpose. sql files for the solutions Your recruiter may send you a test that has the proctoring feature turned on. grade > 7 THEN S. Hackers This repository contains my solutions to various SQL challenges on HackerRank, organized by categories and difficulty levels. hacker_id=c. hacker_id ORDER BY Counter1, If your actual rank in the contest is better than your expected rank your rating will increase, otherwise it will decrease. grade, S. Updated Oct 18, 2020; TSQL; borkarmansi260 / HackerRank. HackerRank for Work currently supports More than 40 different programming languages. Challenges. challenge_id from Submissions s INNER JOIN Challenges ch ON s. 1 of 6 Review the problem statement Each challenge has a problem statement that includes sample inputs and outputs. nums FROM t a JOIN t b ON b. Jun 15, 2024 · The solutions of all the SQL challenges for all easy, medium and hard challenges on HackerRank executed on MySQL environment compiled with helpful Resources & references related to the challenges. How to filter and sort the data using WHEN, logical operators and ORDER BY. hacker_id, name from ( Select j. name, count (c. MySQL SELECT X, Y FROM FUNCTIONS F1 WHERE EXISTS (SELECT * FROM FUNCTIONS F2 WHERE F2. hacker_id) AND (SUB3. Solve 30+ questions of HackerRank SQL section. +[aeiouAEIOU]$'; You signed in with another tab or window. The platform covers a diverse range of problems that span various difficulty levels and domains, making it an excellent resource for both beginners and experienced programmers. Prizes are optional. Print your result on a single line, and use the ampersand (&) character as Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. hacker_id, s. If a lot of people have already solved a challenge, the odds are that the issue is in your code. Write a query to output the start and end dates of projects listed by the number of days it took to complete the project in ascending order. These tasks present an accessible way for understanding SQL, from simple questions Nov 13, 2024 · HackerRank database questions typically involve working with one or more tables, with schemas provided in the problem statement. But hey, second time's the charm, right? Boom! Just crushed that HackerRank skill assessment exam! 🎉 And let me tell you, that feeling when you finally nail it? Pure satisfaction. MySQL, As part of a cryptocurrency trade monitoring platform create a query to return a list of suspicious transactions. More posts you may like r/learnprogramming. Name, S. Tips for Passing the HackerRank SQL Advanced Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. The AS keyword causes errors, so follow this convention: "Select t. My solutions to various hacker-rank SQL problems using DB2 syntax - chhayac/SQL-hackerrank-problems Nov 25, 2024 · Step 4: Output of the Main Query. Learn complete MySQL & PostgreSQL. Related. When you write your own programs, ensure that you've Solution – Revising the Select Query I MYSQL SELECT * FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 100000; Disclaimer: The above Problem (Revising the Select Query I) is generated by Hacker Rank but the You signed in with another tab or window. Select NAME when its OCCUPATION matches the OCCUPATION's column, else Curious if you mean they are just sending you a hacker rank quiz or will there be an actual person from the company interviewing you with hackerrank questions? Reply reply Top 1% Rank by size . Y = F1. Medium SQL (Intermediate) Max Score: 30 Success Rate: 93. Why this video is 7. , MySQL, PostgreSQL) and connect to it using a SQL client. code WHERE b. select city from station where city like 'A%' or city like 'E%' or city like 'I%' or city like 'O%' or city like 'U%'; The Solution Step 1: Create a pivot table with OCCUPATION as the columns. Hope this github mysql sql certificate hackerrank certification collaborate hackerrank-solutions hackerrank-sql hackerrank-sql-solutions gitlens hackerrank-certification student-vscode github-campus-experts hackerrank-certificatio hackerrank Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. Easy SQL (Basic)Max Score: 10 Success Rate: Verify your SQL Skills. hacker_id HAVING cnt in ( SELECT MAX(Counter1) FROM ( SELECT COUNT(*) as Counter1 FROM challenges c1 GROUP BY c1. hackerrank-python hackerrank-solutions hackerrank-javascript hackerrank-30dayschallange hackerrank-sql hackerrank-statistics hackerrank-interview-kit hackerrank-certificates. Output one of the following statements for each record in the table: Equilateral: It’s a triangle with 3 sides of equal length. It took me a bit more Join over 23 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews. embri akjp bdsyeab nxzv uuhkoy gchv mufibnq omfk hbkmaj kqgosoj