Complex sql queries for practice with answers punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
... are three very successful websites that sale high quality custom clothing labels in small quantities to several thousand SME as well as individuals who need to mark clothes with great good looking labels of professional quality. Since 2011, the business has enjoyed a steady growth of happy customer and an excellent track record of sales. Following this success we are now expanding to Russian speaking customers via a new website targeting Russia, Ukraine, Belarus and EU Baltic states such as Estonia, Latvia and Lithuania. We are seeking a dynamic eCommerce Manager to assure success again. Location: For training purposes, preferably (and initially) the ideal candidate should be based close to Tallinn, but this can be discussed. However, once the manager is onboard a...
Graphic design, also known as communication design, is the art and practice of planning and projecting ideas and experiences with visual and textual content.
As a newly established cyber company, I am looking for a skilled web developer to create an lead generating and informational platform for our business. This website will serve as our primary tool for selling our services and solutions online. Key Features: - The most crucial feature of this website will be the Contact Form. It is vital that potential clients can easily reach out to us with queries or service requests. Products/Services: - The primary focus of the website will be to sell our services and solutions. Therefore, the website needs to be designed in a way that effectively showcases our services and solutions and makes it easy for customers to engage with them. Ideal Skills & Experience: - Proficiency in lead generating ...
We are seeking a skilled AI developer to create a custom AI script capable of generating answers based on specific datasets for multiple products. This AI model will provide accurate responses using only the data provided for each product. If the model cannot find a matching answer, it should prompt the user to contact us for further assistance.
We are seeking a skilled AI developer to create a custom AI script capable of generating answers based on specific datasets for multiple products. This AI model will provide accurate responses using only the data provided for each product. If the model cannot find a matching answer, it should prompt the user to contact us for further assistance.
...designer to create an end-to-end game specification for a captivating and uncomplicated game for mobile devices. - Target Audience: The game is designed to be accessible to all age groups, so it should have a universal appeal and be easy to understand and play. - Primary Goal: The game's core objective is to entertain the players. It should be engaging and provide a satisfying gaming experience. - Preferred Genre/Style: The game falls under the category of hand and mind coordination. This indicates that the game will challenge the player's ability to quickly and accurately coordinate their hands with their mental processes. Ideal skills and experience for this job include: - Proven track record of designing successful mobile games with mas...
...SEND YOUR SAMPLE VIDEO FIRST TO BE SELECTED I need someone to create videos on English Grammar on the topics given here in the attachment. It can be discussed in Chat. You should have a good, professional grade Mic. An electronic Pen is desirable. Topics for which you need to create the videos are Narration , voice change, parts of speech, sequence of tense, gerund, creating wh questions etc. Each topic should be minimum of 60 minutes length. You first need to explain the main concept, use examples and use some questions and then its answers with explanation.. also create 10 MCQ questions on each topic. Instructions to be in ENGLISH only. Use Screen recording Software and/or Whiteboard. VOICE MUST BE LOUD & CLEAR. NO BACKGROUND NOISE/SHAKY VIDEOS NOT ALLOWED. Se...
I'm on the hunt for an experienced sales professional with a particular strength in client relationship management. Key Responsibilities: - Primarily, you will be handling the re-negotiation of contracts with our clients. Given the complex nature of this role, I require someone who has an advanced level of expertise in contract re-negotiation. Ideal Skills: - Advanced understanding of contract re-negotiations within sales - Previous experience in long-term client relationship management - Excellent communication and negotiation skills If you have a solid track record in improving client contracts while maintaining strong relationships, please bid on this project. Preference will be given to those with a proven history in the field.
...consultant to handle sales for a comprehensive range of services aimed specifically at small businesses. Key Responsibilities: - Perform END TO END sales for the cyber security solution and service and Hr staffing sales The ideal candidate should have: - Proven sales experience in the cyber security industry, particularly with small businesses or large Business - Strong understanding of the cyber security landscape and the ability to communicate complex security concepts in a clear and concise manner. - Excellent interpersonal and communication skills, with the ability to build and maintain strong client relationships. - Prior experience with vulnerability assessments, managed security services and cyber security HR services is a plus. T...
I am looking for a skilled and experienced business lawyer based in California. The main task at hand is to file a lawsuit already prepared in the Superior Court for a case involving fraud. The lawsuit will not be served initially. You must be licensed in California or please don't apply. Requirements: - Expertise in business law: You should have a deep understanding of California business laws and Superior Court processes. - Experience in fraud cases: Previous experience in handling fraud cases is highly desired. - Strong litigation skills: The ideal candidate should have a proven track record in litigation, particularly in the Superior Court. - Excellent communication: Clear and concise communication is crucial in this role, as you will need to explain complex...
...able to search for trainers or classes based on the city or trainer's name. This will make it easy for students to find trainers that are close to them or whom they may have heard of. - **User Profiles**: Each trainer or class should have a detailed profile which includes: - Biography: A brief description of the trainer and their training methods. - Reviews and Ratings: Users should be able to rate and write reviews about the trainers/classes. - Contact Information: Trainers should be able to list their contact information so that interested students can get in touch with them. The ideal candidate for this project should have experience in developing complex web portals with multiple user types, advanced search functionality, and...
Dear translator, We are a company that develops live streaming and video chat apps. We are looking for native translators in various languages for a localization project regarding the FAQ sections of our apps. We will be sharing a Sheets file with the texts that contains HTML codes and placeholders, Therefore, this project requires a lot of close attention to detail and preferably, past experience working with HTML codes. The file has two tabs. The first one needs to be localized, while the second tab needs to be proofread. The tone of the translations should be friendly, inviting, and informal. The first tab is 1800-words-long, but a considerable amount of the answers has repetitions. The second tab is 932 words-long in English. Ideally, we will be ...
I'm looking for a knowledgeable individual in the field of Mathematics, specifically Graph Theory, who can efficiently and accurately rewrite my research. The primary goal here is to create a fresh version with distinct wording while preserving the important findings and messages. The main section requiring your expertise is the Methodology. I expect a comprehension of mathematical concepts and a strong proficiency in interpreting and rewriting complex research methodologies in a clear, engaging manner. Key Skills & Experience: - Proficient in English - Mathematics, specifically Graph Theory - Exceptional writing and editing skills - Experience in research re-writing. - Solid understanding of research methodologies. Please only bid if you can demonstrate y...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...PHP developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this...
I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy &...
I am looking for an exceptional PowerPoint designer who can use a professional theme and color scheme to turn my financial transformation metrics into an engaging, compelling presentation - one that's set to impress at an upcoming award ceremony. Key Duties: - Design a 20-slide PowerPoint presentation focusing on the financial transformation metrics of a large organization. - Use a professional color scheme that matches the tone of the event and makes the charts and graphs easy to understand. - Make the presentation engaging, logical yet impressive to the jury at an award ceremony. Ideal Skills and Experience: - Excellent PowerPoint design skills. - Experience in interpreting financial metrics and transforming them into captivating visuals and slides. - Understanding of the...
I have import an avatar with an animation from Daz to Clo. I want dress it with a complex bikini with a belt. This is not stable in the animation. I need help.
...services like Rapido, Ola, or Uber, with a few unique twists. The app will cater the general public users, offering them a seamless, user-friendly, and secure platform for booking rides. Key Features: - GPS Tracking: The app must have a reliable GPS tracking feature to ensure accurate location-based services. - Ride Booking: A well-optimized booking system that allows users to easily book, cancel, and track their rides. - Payment Integration: Secure, efficient, and user-friendly payment gateways to facilitate smooth transactions. The budget is 2500-3000 INR Cross-Platform Development: The app should be available on multiple platforms including iOS, Android, and Web, ensuring a wide accessibility and user base. Ideal Candidate: - A seasoned app developer with a...
I am looking for an experienced and skillful data analyst or statistician who can help me present a detailed paper explaining data analysis techniques, with a special emphasis on Multivariate Test Effect Pillai's and Descriptive Statistics. what I need in this project is to explain for me how and why the calculation is done in this way in the paper that I will provide you later on so the statistic analysis is already done. I only need the explanation for my own understanding. So is there any possible way that we can conduct this explanation exercise today The target audience for this paper are academics and researchers, therefore, the tone and depth of the content should accommodate this group effectively. The ideal freelancer should have: - A ...
Job Summary The Program Manager will be instrumental in shaping our operational strategies and enriching support systems for startups within the Web3 and DeFi sectors. This role requires a proactive individual to enhance our accelerator’s offerings and ensure they are perfectly aligned with the needs of startups in this rapidly evolving industry. Key Responsibilities Design, implement, and refine accelerator program structures specifically tailored for Web3 and DeFi startups. Facilitate seamless coordination across internal teams and external partners, ensuring alignment with the DAO’s token economy and governance structures. Develop and maintain strategic partnerships critical to the blockchain ecosystem. Manage the logistical and organizational as...
...Python to build an advanced trading bot. The bot should be compatible with TradingView and capable of the following: - Generating buy and sell signals based on specified trading strategies - Implementing stop loss and take profit orders for risk management - Adapting to customizable trading strategies - Actually executing trades and proving profitable over time The ideal candidate should have: - Profound understanding of trading principles and market dynamics - Solid experience in developing trading bots and implementing complex trading strategies - Proficiency in Python and experience in integrating with TradingView - A track record of building successful, profitable trading bots This project is a great opportunity for someone looking to apply adv...
I'm in need of a talented game designer who can create a 3D puzzle game suitable for adults on both Android and IOS platforms. Key Requirements: - **Game Type:** The ideal candidate should have a good grasp of designing puzzle games with a 3D interface. The game should be engaging and challenging, yet not overly complex. - **Target Audience:** The target demographic for this game is adults. I expect the freelancer to cater the game’s design, difficulty levels and overall gameplay to this age group. - **Graphical Quality:** The game should be designed with a 'cartoonish and simple' aesthetic. This means our target is a game that is visually pleasing but not overly complex or demanding on resources. Skills & Experience:...
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of t...maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integrity. - Attention to detail: Given the complexity of the layout, a keen eye for detail is crucial. Every element from the PDF should be accurately reflected in the Excel document. - Experience with image embedding: Some images are included in the PDF. You should be able to embed these images into the Excel document without los...
I'm looking for an experienced Django developer to work on the backend of my project. Key Project Goals: - The primary focus of this project is on backend development. You should have a strong understanding of Django and be able to handle complex backend tasks. Ideal Skills and Experience: - Extensive experience with Django is a must. - Strong understanding of backend development. - Ability to work on complex backend tasks. - Good communication skills. - Previous experience with similar projects is a plus. Please note that the project is already defined and the focus will be solely on backend tasks. Your role will be to improve the backend of the website. Feel free to ask any questions for more information.
...written a Python code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple...
I'm seeking 2-5 experienced tele callers who can effectively communicate about commercial real estate properties. The ideal candidates should possess: - Strong communication skills in English - Proven experience in the real estate sector, particularly with commercial properties - Exceptional phone etiquette and persuasion skills - An ability to handle client queries professionally Your primary task will be reaching out to potential clients to discuss our available commercial real estate listings. Please submit your proposal highlighting your related experience and successful projects.
As a proactive website owner, I'm currently experiencing issues with the search bar on my site. It suffers from slow loading speed and provides irrelevant results, causing a less than ideal user experience. The existing search feature has been built using PHP. To improve the functionality and user satisfaction, I'm seeking a professional with vast experience in PHP who can implement critical improvements. - Autocomplete Function: For faster and user-friendly search queries, incorporate a reliable autocomplete function. Having this feature can save users' time and enhance the browsing experience. - Enhanced Filtering Options: Alongside the autocomplete feature, the search bar needs to have advanced filtering options to serve the most releva...
...children and communities, rights of children and inclusive and democratic learning style Key Responsibilities: - Break down complex empowerment strategies into simple, actionable steps. - Use compelling and motivational language to inspire new teachers in their journey. Ideal Skills: - Proven experience writing in an inspirational and motivational style. - Familiarity with the field of education, specifically teacher empowerment. - Exceptional ability to engage and inspire novice educators through writing. - Capacity to maintain reader engagement with compelling narrative style. The goal of this project is to create a comprehensive tool that will serve as a robust resource for novice teachers, helping them find their voice, build confidence, and master the...
...presentation is to provide education and training, specifically catered to an audience of external clients. Ideal Specs and Experiences: - Expert in PowerPoint presentations - Understanding of business and training materials - Proven ability in creating engaging content for an external client base - Articulate in explaining complex business concepts in an easy-to-understand manner. Roles and Responsibilities: - Develop a PowerPoint presentation emphasizing business education and training - Ensure it's targeted appropriately for an external client audience. - Content should be engaging, easy to understand, and professionally done. - Aim to astutely educate and keep the audience engaged. - Must be able to make any necessary edits based on feedback. The final ...
I have a photo where I would like to remove a person who is on the side. (Want to keep only the girl in the black shirt) remove the other one on the left of her Key requirements: - Remove the person on the side of the photo while keeping the background intact. The background is mixed, with some areas more complex than others. It's essential that the background maintains its original look, even after the person is removed. - The final use of the edited photo will be for personal use, so the editing needs to be of a high quality. Ideal freelancer: - Previous experience in photo editing, specifically in object removal while maintaining the background. - Proficiency in tools like Photoshop or similar software. - Attention to detail and ability to deliver a...
I require a highly intricate and large-sized STL design specifically tailored towards 3D printing needs. Ideal skills and experience for the job: - Proficient in STL file designing and 3D modeling. - Extensive experience with intricate and large-sized 3D designs. - Strong knowledge of 3D printing. Key requirements: - Develop a large STL design with high intricacy. - Ensure design is optimized for 3D printing. - Deliver in a timely manner and maintain good communication.
...looking for a seasoned medical illustrator, ideally with a strong background in cardiovascular disease pathology. Your task will be to create a feature illustration for a magazine "Nature" article on cardiovascular diseases. The style needs to be ccompatible with their style Responsibilities: - Scrutinizing the article content thoroughly - Designing an appealing, realistic illustration that depicts the topic accurately - Getting my approval of sketches before moving onto final work Skills and Experience: - In-depth understanding and ability to illustrate cardiovascular diseases - Excellent grasp of realistic visual art styles - Strong medical illustration track record - Proven experience working with scientific or medical content will be a h...
...looking for a professional designer to help me refresh my logo as part of a rebranding effort. I've decided to stay with the existing color scheme, font style, and symbol/icon, but I want to modernize and freshen the overall look. Key Points: - The redesign is part of a rebranding exercise, so the new logo should align with my updated brand identity. - I wish to maintain the current color scheme, font style, and symbol/icon, but I'm open to their reinterpretation. - The new logo should reflect a minimalist, vibrant, and slightly vintage-inspired aesthetic, steering clear of being too busy or complex. Ideal Skills and Experience: - Extensive experience in logo design, particularly in the context of rebranding. - Proficiency in working with e...
Hi I'm about to advertising a learning course. ...6 weeks, and I want to use moodle to post course materials, and interact with the course participants. A draft of the course information is attached. I'm looking for a freelancer who can support me with my Moodle platform. I have never used moodle before, so I need help with installation and setup, and ensuring that our required functionality is possible. I am working with an assistant and we both need to be able to access the participant forums to respond to queries, and to upload and receive materials. Please provide a succinct proposal, and an expectation of how long this would take. I am after a very simple solution at this stage, as the moodle element is only for commu...
As a startup, I'm preparing for an upcoming competition and I need a modern pitch deck that will help me stand out. I'm looking for a designer who can help me in creating a compelling and visually appealing deck that will grab the attention of the judges. Key Requirements: - Modern design style: I need a sleek, modern pitch deck that aligns with current design trends. - Concise & effective: Given that the competition will be fast-paced, I'm looking for a pitch deck with fewer than 10 slides that effectively communicates my business idea. Ideal Freelancer: - Experience in creating pitch decks for startups or competitions. - Strong design skills, particularly in modern or minimalist styles. - Ability to distill complex ...
...Python developer with a proven track record in working with the Scrapy framework. The primary goal of the project is to handle data extraction from websites, dealing particularly with nested or hierarchical data. Key Responsibilities: - Collaborating with the team to define the scope of the project and identify the data requirements. - Design and implement data extraction scripts using the Scrapy framework. - Handle complex, nested or hierarchical data structures. - Ensure the accuracy and efficiency of the data extraction process. Ideal Skills and Experience: - Proven experience in Python development. - Expertise in working with the Scrapy framework. - Strong understanding of web technologies and data structures. - Excellent problem-solving a...
I need someone to write detailed, informative, and neutral book summaries for a series of non-fiction history books in Tamil in 1500 words per book. I need one or 2 book summaries. Book of your choice Some key points about this project: - Each book summary should be comprehensive yet concise, capturing the key points and essence of the book - You should be able to write in a clear, engaging and neutral style, avoiding any personal bias or opinion - The summaries should be presented in an essay format Ideal Skills and Experience: - Proficient in Tamil language, with a strong grasp of grammar and vocabulary - Experience in summarizing and distilling complex information into clear, concise summaries - Ability to write in a neutral and informative tone - Preference will...
I'm in need of a highly skilled and advanced CISSP trainer for on-prem training in Kuwait. The training will be for a small group of 1-10 participants. The ideal candidate should be able to provide the following training materials: - Comprehensive printed manuals and handouts - Digital copies (PDFs, slides) for participants to refer to post-training - Practice exams and quizzes to help reinforce learning and assess understanding The trainer will be expected to travel to Kuwait for this assignment. Experience in providing CISSP training in a physical setting, particularly in the Middle East, would be a significant advantage. The ideal candidate should be able to deliver complex CISSP concepts in a clear and engaging manner, ensuring participan...
...skilled writer with a background in medical and legal affairs? Do you have a keen awareness of defamation issues? We’re looking for a talented individual to collaborate with us on a project that delves into sensitive topics within the medical and legal realms. Requirements: • Experience in writing about medical and legal affairs. • Knowledge of defamation issues and the ability to navigate them effectively. • Strong research skills to ensure accuracy and credibility. • Excellent communication skills to collaborate with our team effectively. • Confidentiality and professionalism are a must. Responsibilities: • Co-create compelling content within the medical and legal domains. • Conduct thorough research to en...
...infrastructure, cloud solutions, Virtualization and datacenter modernatizatio and a knack for translating complex technical concepts into clear, concise writing? We're seeking a skilled freelancer to create informative papers on various aspects mentioned below The ideal candidate will possess the following qualifications: In-depth knowledge of leading HCI solutions: VMware vSAN, NSX, HCX, Azure Stack HCI, etc. Solid grasp of HCI architecture: Distributed storage, software-defined networking, and resource management. Experience deploying, configuring, and managing HCI clusters: Proven track record of hands-on experience. Cloud Platforms : Proficency in major cloud platform like Azure, AWS or GCP. Experience with cloud automation tools, and automating infra...
I'm looking for someone to convert a PDF document into a Word document. The main purpose of this conversion is to extract text from the PDF content which has complex formatting, including elements such as tables and footnotes. Key Requirements: - Accurate Extraction: The primary goal here is to ensure that all text is accurately extracted from the PDF file and transferred to the Word document without any loss or distortion. - Formatting Preservation: While the layout may be complex, I'm looking for the freelancer to maintain the font styles and sizes as they appear in the original document. The ideal candidate for this job would have: - Proficiency in PDF and Word processing tools - Experience with maintaining formatting during content...
I a...looking for a graphic designer to create the header of my prescription paper. I'd like the header to include: - My name and credentials - The name and address of my clinic - Contact information including phone number, email, and website - Basically, I have attached a sample Heade File, the data I need is the same as given. Need very clear and vibrant design, latest design. Doctor name font should be very standard and clear. The header should be designed to fit an A4 paper size. I don't have a specific colour scheme in mind, so you have creative freedom in that aspect. Ideal skills for this job include graphic design and a good understanding of branding and visual hierarchy. The header must look professional and clean, while also having a cohesive design t...
I am looking for a Python developer who can implement concepts from a research paper. - The developer must have solid experience in Python, ideally with an intermediate understanding of complex programming concepts. They should be comfortable with an intermediate level of complexity in translating research concepts into code. - Knowledge and experience with the PyTorch framework is a must. The freelancer will need to use it to implement the code from the research paper. This project will require a good understanding of data structures, algorithms, and object-oriented programming in Python. Experience with prior work involving code implementation from research papers would be advantageous. Please only bid if you meet these qualifications and c...
I am looking for an experienced writer who can create educational blockchain articles specifically focusing on supply chain finance. The aim of these articles is to inform and engage with academic researchers within the financial sector. Key Requirements: - Extensive knowledge and experience in blockchain technology and supply chain finance - Proven experience in creating educational content for an academic audience - Ability to explain complex concepts in a clear and accessible manner - Strong research skills to ensure accuracy and credibility of the content The perfect candidate should have a strong background in both blockchain technology and supply chain finance. Previous experience in creating educational content for an academic audience is highly ...
I am on the hunt for a creative and talented freelancer to design an engaging company profile in PowerPoint format. This content rich profile will contain detailed information such as our company's history, mission and vision, and the products and services we offer. Given that the target audience is our potential customers, skills in marketing and great understanding of customer demographics will be highly regarded. Proficiency in PowerPoint is a must along with the ability to convey complex information in an easy-to-understand manner. A background in corporate storytelling or alike will be a significant plus. Ideal skills include: - Expertise in PowerPoint - Brilliant storytelling abilities - Understanding of customer demographics - Background in Marketing o...
