ellz

...
order by views asc

...
order by sum(views) asc

select views, image_url, (select avg(votes.value))
  from images
 inner join votes 
     on votes.image_id = images.id
 group by views, image_url
 order by views asc

from django.db import connection

some_arg = 42

c = connection.cursor()
try:
    c.callproc('some_stored_procedure', (some_arg,))
    r = c.fetchone()
    ...
finally:
    c.close()

...
inner join (select distinct hotelId,price from Tours)

(SELECT MIN( hotelsRooms.price) FROM hotelsRooms WHERE hotelsRooms.HotelID = hotels.Id ) as MinPrice

[Tours]
    [HotelID]         INT            NOT NULL
    [CityID]          INT            NOT NULL,
    [CountryID]       INT            NOT NULL,

SELECT Hotels.[Name] AS HotelName, 
       Cities.[Name] AS CityName, 
       Countrys.[Name] AS CounrtyName,
       (SELECT MIN(Price)
          FROM HotelsRooms
          WHERE (HotelID = Hotels.ID)) AS MinPrice, 
        Hotels.Rating AS Stars, 
        Hotels.Line, 
        Hotels.DistanceToBeach, 
        Hotels.DistanceToAirport
  FROM Hotels 
    INNER JOIN Cities ON Hotels.City = Cities.ID 
    INNER JOIN Countrys ON Cities.CountryID = Countrys.ID
  WHERE ((@toCity IS NULL) OR (Cities.[Name] = @toCity)) 
    AND ((@toCountry IS NULL) OR (Countrys.[Name] = @toCountry))

SELECT MIN(Price) FROM HotelsRooms WHERE (HotelID = 14)

SELECT        (SELECT        MIN(Price) AS Expr1
                          FROM            HotelsRooms
                          WHERE        (HotelID = 14)) AS Expr1
FROM            Hotels
WHERE        (Id = 14)

SELECT        (SELECT        MIN(Price) AS Expr1
                          FROM            HotelsRooms
                          WHERE        (HotelID = Hotels.Id)) AS MinPrice
FROM            Hotels
WHERE        (Id = 14)

[Tours]
    [HotelID]         INT            NOT NULL
    [CityID]          INT            NOT NULL,
    [CountryID]       INT            NOT NULL,

Указал - не помогло.

DECLARE @cityNameTest nvarchar(100)
SET @cityNameTest = N'Название города'
SELECT 1 WHERE @cityName = @cityNameTest

SELECT @CityID = Id FROM Cities WHERE [Name] = @cityName
IF @CityID IS NULL BEGIN
  INSERT Cities([Name]) VALUE (@cityName)
  SET @CityID = IDENT_CURRENT('Cities')
END

{
  "cities": [{
    "CountryName": [{
        "name": "Sentra"
      },
      {
        "name": "Sentra"
      },
      {
        "name": "Sentra"
      }
    ],
    "CountryName2": [{
        "name": "Sentra"
      },
      {
        "name": "Sentra"
      }
    ]
  }
]
}

public class Tours
    {
        public List<TourInfo> tourInfos { get; set; }
    }

tours.tourInfos[0].beachType = "one";// здесь возникает ошибка | И правильно, потому что tours.tourInfos - null
            tours.tourInfos[1].beachType = "two";

tours.tourInfos[0].beachType = "one";// здесь возникает ошибка
            tours.tourInfos[1].beachType = "two";

По идеи должна вернутся строка с двумя JSON массивами, где все кроме beachType будет null.

ArgumentOutOfRangeException
startIndex is negative or greater than the length of this instance.

System.Diagnostics.Process.Start(@"C:\Windows\system32\dfrgui.exe");

Или как такое гуглить на английском?

1. Обвернуть строку в квадратные скобки [ ] с обеих сторон и тогда можно интерпретировать итоговую строку как JSON:
   

   [{" level " : 1 , " moves " : 15}, {" level " : 2 , " moves " : 28}, {" level " : 3 , " moves " : 25}]

   
   
   
2. При помощи средств парсинга JSON получить массив объектов,
   
3. в котором (при помощи LINQ) найти объект, у которого искомый level, и взять значение его moves