sguzunov

select sportgroups.id as sportgroupId, sports.name as sport, sportgroups.location as location
from sports join sportgroups
on sports.id in (
	select sport_id
    from sportgroups
    where sportgroups.location like 'Sofia'
);

sguzunov

select sportgroups.id as sportgroupId, sports.name as sport, sportgroups.location as location
from sportgroups join sports
on sportgroups.sport_id = sports.id
where sportgroups.location like '%Sofia%';

sguzunov

select sportgroups.id as sportgroupId, sports.name as sport, sportgroups.location as location
from sports join sportgroups
on sports.id in (
	select sport_id
    from sportgroups
    where sportgroups.location like '%Sofia%'
);

sguzunov

namespace Rectangles
{
    /*
        Write an expression that calculates rectangle’s area and perimeter by given width and height. The width and height should be read from the console.
    */

    using System;
    using System.Globalization;
    using System.Threading;

sguzunov

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo
{
    class Program
    {

sguzunov

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo
{
    class Program
    {

sguzunov

/* Write a program that, for a given two integer numbers N and x, calculates the sum S = 1 + 1!/x + 2!/x2 + … + N!/xN. */

using System;

class Calculate
{
    static void Main()
    {
        int n = int.Parse(Console.ReadLine());
        double x = double.Parse(Console.ReadLine());

sguzunov

using System;

class TextToNumber
{
    static void Main()
    {
        long result = 0;
        int module = int.Parse(Console.ReadLine());
        string text = Console.ReadLine();

sguzunov

using System;

class Program
{
    private const char SpaceSign = ' ';
    private const char DotSign = '.';
    private const char XSign = 'X';
    private const char SlashSign = '/';
    private const char BackSlashSign = '\\';
    private const char HashTagSign = '#';

sguzunov

// Copy Code Snippet Hereusing System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace case_3
{
    class Program
    {