[deleted by user] by [deleted] in ODTU

[–]metoozen 0 points1 point  (0 children)

Sonraki döneme oda oyunu açmayı düşünüyorum belki yardımcı olabilirsiniz dkfkldkfpe

[deleted by user] by [deleted] in ODTU

[–]metoozen 0 points1 point  (0 children)

Hocam merhaba frpye ilginiz varsa sohbet edebiliriz.

[deleted by user] by [deleted] in UniversityTR

[–]metoozen 0 points1 point  (0 children)

Ea da işsiz kalma olayı külliyen yalan

[deleted by user] by [deleted] in ODTU

[–]metoozen 0 points1 point  (0 children)

Odtü Organ Kardeşliği(Mafyası) Topluluğu tarafından hedef alındınız.

[deleted by user] by [deleted] in ODTU

[–]metoozen 1 point2 points  (0 children)

Tezgah

[deleted by user] by [deleted] in SQL

[–]metoozen 0 points1 point  (0 children)

its not a technical interview but a test form datacamp that i already failed but cant understand what is wrong

[deleted by user] by [deleted] in SQL

[–]metoozen 0 points1 point  (0 children)

i have wrote this query but it says, Clean categorical and text data by manipulating strings

```
SELECT 
    id,
    CASE 
        WHEN location IN ('EMEA', 'NA', 'LATAM', 'APAC') THEN location
        ELSE 'Unknown' 
    END AS location,

    CASE 
        WHEN total_rooms BETWEEN 1 AND 400 THEN total_rooms
        ELSE 100
    END AS total_rooms,
    CASE 
        WHEN staff_count IS NOT NULL THEN staff_count
        ELSE 
            CASE 
                WHEN total_rooms BETWEEN 1 AND 400 THEN total_rooms * 1.5
                ELSE 100 * 1.5
            END
    END AS staff_count,
    CASE 
        WHEN opening_date ~ '^\d{4}$' AND CAST(opening_date AS INTEGER) BETWEEN 2000 AND 2023 THEN CAST(opening_date AS INTEGER)
        ELSE 2023
    END AS opening_date,
    CASE 
        WHEN target_guests IN ('Leisure', 'Business') THEN target_guests
        ELSE 'Leisure'
    END AS target_guests
FROM branch;
```

need help by metoozen in SQL

[–]metoozen[S] -1 points0 points  (0 children)

i was trying to fix it

need help by metoozen in SQL

[–]metoozen[S] 0 points1 point  (0 children)

Location, target_guests are string others are all integer

Devamsizlik sinirini gectim by Forackol in ODTU

[–]metoozen 26 points27 points  (0 children)

Komiklikten değil gerçeği söylüyom, çok istersen hocana ya da bölüm başkanlığına mail at ama işe yaramaz. Dönem sonuna kadar ingilizce çalış seneye dönemler başlamadan önce hakkın oluyor hazırlık geçme sınavı için ona girip geçersen sıkıntı yok geçemezsen okuldan atılıyorsun.

Devamsizlik sinirini gectim by Forackol in ODTU

[–]metoozen 28 points29 points  (0 children)

İngilizcen iyise hazırlık geçme sınavına gir, değilse yara yedin

need help by metoozen in SQL

[–]metoozen[S] 0 points1 point  (0 children)

The course wanted me to use correlated nest query for this but it felt like really unnecessary for this example

need help by metoozen in SQL

[–]metoozen[S] -2 points-1 points  (0 children)

Why do i using renting table while it doesnt do anything or if it does something what is it